SCD taking very long to load a table
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
May 2nd, 2011 4:35pm
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
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 4:55pm
This topic is archived. No further replies will be accepted.
Other recent topics
