My source is Views in SQL 2008 . I have read only access there . At destination the environment is Same sql 2008 and I have all the permissions. My problem is that I am implementing SCD Type 1 but the table has 400,000 records and SCD is taking forever to load the data . What are other efficient ways to solve this problem in SSIS or SQL . Thanks! arun

Hello Arun, Are you using SCD Transforamtion? Or OLEDB Command Transformation? These transformations are slow. IF you have everything on the same server, USE TSQL , You can use Merge Statement to have SCD1 type data. link: http://blogs.microsoft.co.il/blogs/bursteg/archive/2007/12/06/sql-server-2008-t-sql-merge-statement.aspx Thanks http://sqlage.blogspot.com/

I am using SCD transformation and it generated OLEDB for updates and My source is on different server and destination is on different server. Thanks arun

The standard SCD is slow. Here are some alternatives for the SCD: http://microsoft-ssis.blogspot.com/2011/01/slowly-changing-dimension-alternatives.html Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com