-
SSIS question
I created a package that would move data from one sql table (200+ fields) to another sql table(20+ fields) in different domains. The source table gets updated every night by a bulk load then I'm scheduling the package to run the next morning to move data to the destination table. Which transformation do I use to only load new data and ignore existing data?
-
You have use a query to define source as only changed data. There is no native transformation to give you only changed data in SQL 2005, SQL 2008 has change data capture feature.
-
Originally Posted by Picha Pie
I created a package that would move data from one sql table (200+ fields) to another sql table(20+ fields) in different domains. The source table gets updated every night by a bulk load then I'm scheduling the package to run the next morning to move data to the destination table. Which transformation do I use to only load new data and ignore existing data?
U can TRY Slowly changing Dimension. It will allow you to insert New data base on a buisness key.
-
Don't think they are on same page.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|