MSSQLTips

This post is related to this tip: Handling Slowly Changing Dimensions in SQL Server Integration Services (SSIS) Packages

http://www.mssqltips.com/tip.asp?tip=1442

hi

i had a problem with dealing this if i delete any row then the primary key column generating new column which is an identity column so when ever i running the package a new row is inserting can you help on this problem

 Are you saying that you deleted a row from the dimension table then when you rerun the package it gets inserted again from the source?  If so then you want to add a deleted flag column to the dimension.  Rather than physically deleting the row you set the deleted flag.  Then the package won't add the deleted row back.