Set a foreach to a file connection
Fri, 12 Mar 2010 08:52:58 -0800 (PST)
Hiya,
So I am in SQL Server Business Intelligence Development Studio 2008. I
have a Foreach file enumerator and a file connection that points to a
folder. I only see browse and can only enter a folder path text under
the foreach properties now (enumerator configuration). But I really
need to set the folder dy ...
|
SSIS package - how to determine if a file is in use.
Wed, 3 Mar 2010 14:44:01 -0800
I have several SSIS packages that import data from files. I am having
trouble reliably determining whether a file is in use. I am working in
Visual Studio 2005. I am creating SSIS packages for SQL2005. I am importing
data from text files. These text files are written to network directories
from local, ...
|
marvendas@gmail.com Kit completo de Solenoides ( solenoid ) + chicote
Para Cambio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 24883
Fri, 19 Feb 2010 19:24:09 -0800
Contato: marvendas@gmail.com
marvendas @ gmail.com
marvendas no gmail.com
Kit completo de solenoides para Volkswagem e Audi.
O kit contem:
5 solenoides
2 Epc ( solenoides de pressao )
1 Chicote
Serve para qualquer modelo VW ou Audi fabricados de 1995 ate hoje com o cambio automatico de 4 marchas ? 01M
Preço: ...
|
Fact Tables general questions
Wed, 17 Feb 2010 08:40:43 -0800 (PST)
Giving the following senerio.
A wireless phone company Sprints has an application that tracks the
transactions.
A transaction can consist 1 phone sold or a family package (multiple
phones and accessories)
Note: a phone transaction and a package transaction have different
attribubute.
Base on the giving, t ...
|
Poland/Poznan - ETL/Reporting Developer
Fri, 05 Feb 2010 18:39:32 +0100
Poznan - ETL/Reporting Developer
For our international project we are looking for a developer
with ETL and/or reporting experience.
The desired skills include:
Professional project attitude
Self-driven mind-set
Strong project documentation experience
Customer-facing skills
At least 1 year project experie ...
|
下載å…費的å病毒 3365
Tue, 2 Feb 2010 16:19:01 -0800
許å¤?æ?§è?½å?é¡?å??å®?å?¨æ?§æ?¨ç??è¨?ç®?æ©?é? æ?æ?¡æ?ç??æ¯?ï¼?æ??好ç??辦æ³?å°ä»?ï¼?é??æ?¯å¾?å?°æ?¿èªå??é?²ç??æ¯?å?¨è¨?ç®?æ©?ä¸?å®?è£æ?´æ?°
殺æ¯?è»?件å?è²»ä¸?è¼?ï¼?
http://antiviruscn.blogspot.com/
é?æ?¥ç¶²ç«?ç??å?§å®¹ï¼?
http://antiviruscn.blogspot.com/
http://antiviruscn.blogspot.com/2010/01/b ...
|
data type of date columns in dimension: date vs. string
Thu, 14 Jan 2010 14:28:01 -0800
Would you use a date data type for a date column inside a dimension? Or would
you use a string (possibly CHAR(10))?
A date data type can be converted to string at the time of reporting and may
be formatted in a variety of ways. Furthermore one could use the date data
type in queries in the data warehouse. A s ...
|
|
|
How to record changes in the fact table?
Thu, 14 Jan 2010 11:08:02 -0800
Consider a simplified Policy fact table with following columns:
CustomerKey
... bunch of other keys
PolicyMonthlyPremium
At the time a policy is approved (say January 2010) I will create a record
in this fact table.
Then there is a change in the monthly premium (say February 2010). What do I
do? ...
|
how to create FK from fact table to role playing dimensions
Thu, 14 Jan 2010 11:05:01 -0800
Good morning
I am creating our first cube in our relational data warehouse. We are just
learning SASS and will not be moving this to SASS for a while. We are
following the Kimball books for creating facts & dimensions.
Following Kimball's suggestion for role playing dimensions (example: Date):
Should I cr ...
|
Re: ODBC Linked Server & DSN
Wed, 30 Dec 2009 13:21:02 -0800
Great advice. How do I implement this solution?
"Darren Gosbell [MVP]" wrote:
> On Fri, 12 Jan 2007 14:11:04 -0800,
> labsRcoolcommunitynospan@discussions.microsoft.com wrote:
>
> You will need to setup the driver and DSN on the SQL Server machine.
>
> When you issue a query to a linked server, the cli ...
|
