Viewing 15 posts - 16 through 30 (of 30 total)
Can you not just use a set?
WITH SET [DateRange]
AS
( Filter([Enrolement Start Date].[Calendar Date].[Date].Members, [Enrolement Start Date].[Calendar Date].[Date] <=[Enrolement Start Date].[Calendar Date].[Date].&[WhateverDateKey] AND [Enrolement Start Date].[Calendar Date].[Date] >= [Enrolement Start Date].[Calendar...
November 11, 2011 at 8:22 pm
I would think the xmla is going to be your best bet since you have more control over exactly what is processed and how many parrallel jobs can be executed...
August 10, 2011 at 6:45 pm
Looks like this isn't going to be addressed in the next release...bummer
http://connect.microsoft.com/SQLServer/feedback/details/678626/disable-ssis-warning-messages
July 10, 2011 at 8:57 pm
So is this an SSAS processing question?
If so, you probably need to perform the steps above to clean up the tables, then run a ProcessUpdate on the dimension and a...
June 30, 2011 at 9:46 pm
Tim read this differantly then I did, and going back to the orginal request I think his interpertation is correct. Looping through the files will only load them serially.
I...
June 23, 2011 at 11:26 am
Is there something in the filename that differentiates the 10 files from the others? You can use a for each loop with a wildcard file name that is set...
June 22, 2011 at 11:14 pm
It's a function that takes a parameter as the type...don't ask me why, I have no idea.
June 22, 2011 at 1:03 pm
Yes, you cannot select an entire schema in SSIS. This sort of goes against the concept of metadata in the data flow task. I'm not sure why doing...
June 21, 2011 at 2:35 pm
Do you have to use SSIS non-sql task or can you do this in SQL or a sql task. SQL has commands to do things for each object in...
June 21, 2011 at 2:16 pm
Ha, forgot to mark it as code:
(DT_STR,8,1252)(TRIM([Position Entry Date]) == "" ? NULL(DT_WSTR, 50) : (DT_WSTR,50)[Position Entry Date])
June 21, 2011 at 2:09 pm
Your casting syntax is wrong. Also, I use unicode strings when Im dealing with nulls, and then cast it back to non-unicode if I have to afterwards try:
(DT_STR,8,1252)(TRIM([Position Entry...
June 21, 2011 at 2:07 pm
You shouldn't need openrowset enabled on the server. I am talking about openrowset on the excel connection, not the database connection. The excel connection is actually a "database" connection...
June 3, 2011 at 7:58 am
Well, the entire premiss of the data flow task was built around metadata of columns. So when you don't know the metadata it gets interesting. You can build it...
June 3, 2011 at 7:54 am
That's a pretty tall order for a first SSIS package, but I can tell you that passing in variables in SSIS is kind of tricky. You need to use...
June 2, 2011 at 2:16 pm
Multiple sheets is kind of a pain. Actually, Excel is kind of a pain. Depending on your version of SSIS and how you set it up, it could use...
June 2, 2011 at 1:50 pm
Viewing 15 posts - 16 through 30 (of 30 total)