Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tybaltzeke
Starting Member
28 Posts |
 Posted - 2009-04-07 : 16:02:15
|
| i'm designing an application that needs to do 10 lookups to ten different files. i'm pretty new to SSIS. my main question is:- since the output of each transform is a different format, how do i pull all the data back together into one file format in order to finally update the fact table? or do i update the fact table ten times, once for each lookup? would this be done differently if i use the parallel processing features of SQL Server 2008? |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-04-08 : 03:32:31
|
| Do the Lookup Transform to the first file add a derived column and add one more Lookup Transform to second file add a derived column..and so onYou should end up with 10 Lookup Transforms.Is this what you are looking for?http://www.sqlserver007.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-10 : 06:51:15
|
quote:
Originally posted by tybaltzeke
i'm designing an application that needs to do 10 lookups to ten different files. i'm pretty new to SSIS. my main question is:- since the output of each transform is a different format, how do i pull all the data back together into one file format in order to finally update the fact table? or do i update the fact table ten times, once for each lookup? would this be done differently if i use the parallel processing features of SQL Server 2008?
In lookup step you have option to replace column or add as a new column. just select add as a new column and automatically lookup value will also be added to pipeline. just in case you want this value alone instead of source value use replace column |
|
|
|
|
|
|
multiple lookups in parallel , quick design q's