Viewing 5 posts - 1 through 5 (of 5 total)
You could sort the ID's and use merge join transformation to do the lookup.
November 19, 2009 at 2:33 am
gtschech (6/3/2009)
Phil Parkin (5/28/2009)
SSIS requires that you put your data through a sort transformation before using a MERGE JOIN - regardless of whether the source data is already sorted.
Phil,
this is...
June 4, 2009 at 5:14 am
Alexander G. (6/2/2009)
June 4, 2009 at 5:12 am
there's an example of the pivot component usage here: http://sqljunkies.com/Article/705F07C3-69FE-4CAF-8CF8-CADBF145F372.scuk
It doen't have screens but it's pretty clear on how to use it.
April 21, 2009 at 7:16 am
I would suggest using Excel 2007 because of its usability. For example, all measures from all measure groups are put together in Excel 2003 while in Excel 2007 they are...
April 10, 2009 at 5:17 am
Viewing 5 posts - 1 through 5 (of 5 total)