Viewing 15 posts - 16 through 30 (of 45 total)
I would recommend 'Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services ' as a quick reference.
If you work through that even though it is written for 2008 you...
November 6, 2014 at 7:33 am
Thank you both very much. I had a look through the link as well.
It's not something I want to do but saw it in a example project so was...
August 26, 2014 at 7:52 pm
Thanks Jeff, I was just after the idea. I have got the code working after Luis comments.
Thank you to all for replying!
aarionsql (4/2/2014)
April 2, 2014 at 3:18 am
It is a complete horror! Now to model it and prove my point! 😀
April 2, 2014 at 3:16 am
Thank you Luis .. apologies for the late reply. I had no internet access overnight but back in the office now.
I have done this:
Unpivot data
Left Join to Metadata table
Pivot...
April 2, 2014 at 3:15 am
Thank you for that I will check it out.
I have come up with a solution using expressions to rename and move the file using a File System task.
I will provide...
September 22, 2012 at 11:09 am
Thank you so much ... I will try this out this weekend.
I usually try to avoid the script task and component due to lack of confidence but your very detailed...
June 13, 2012 at 1:33 pm
Apologies .. I tried to upload a document which show the structure of the package but for some reason I cannot load an attachment from work .. there are a...
June 12, 2012 at 12:50 am
I don't want a total but an out like you displayed ie
Results look like
NAME TOTAL DAYY BUILD
MR A 1 Monday A
MR A 2 Monday A
MR A 3 Monday A
MR A...
April 25, 2012 at 3:37 pm
Hi .. Thank you all for the suggestions ..
I need create this temp table and join this to main table in a Ssis package .. So it will be...
April 25, 2012 at 2:19 pm
It's is for debugging only.
I will try the conditional split .. The conditions on the split will be looking for the lenght ... I would have never thought if...
April 18, 2012 at 12:20 am
Thank you for your reply. The column is a concatenation of an ID and Date field and there is a truncation error which is stopping the package from running.
Is there...
April 18, 2012 at 12:06 am
The source is Oracle 9i
Looks like I cannot get any error output on any columns which I have 'derived' but I can get out put on the columns where no...
April 17, 2012 at 9:56 am
Having looked at it a bit more the issue seems to be any new columns added to the Derived Component is not being added to the Data-Path of the Error...
April 17, 2012 at 9:27 am
Hi Phil .. I have got stuck in one place.
I am not being able to create an alias ('Table_A_Rank')for the following line:
Table_A_Rank AS (select *, RankMain = ISNULL(rank1,rank2) from...
April 10, 2012 at 10:21 am
Viewing 15 posts - 16 through 30 (of 45 total)