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 |
|
majolamp
Starting Member
15 Posts |
 Posted - 2008-03-04 : 07:07:23
|
| Hi AllI've created an SSIS package that loads data from source to destination, using Lookup and conditional Split to check New rows and changed rows for one table. Now I want to take this father by loading data for multible table more that 100. I did it in T-SQL using dynamic sql and cursor.How can I achive this using SSIS. |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-03-05 : 12:08:11
|
| I beleive dynamic SQL is not avaiable with lookups as it needs meta data to be give before.---------------------http://dineshasanka.spaces.live.com/ |
 |
|
|
|
|
|
SSIS Incremental Load