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.

Quote:

---

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.