SSIS question

[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?

[skhanal]

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.

[i_sanket]

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.

[rmiao]

Don't think they are on same page.