Package Slow
i am working on ssis 2008. my sourse and destination are both sql server. i am using oledb sourse and destination. for loading 3 Core recods its ttok 30 minits. they is no keys and indexs in my destination table. its simply independent table. why its took 30 mints. plz let me know
May 16th, 2011 2:35am

any transformations between the source and destination?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 2:37am

no Trnsformation. only sourse and destination. each time only 7000 recotds were insterd into target table
May 16th, 2011 2:38am

no Trnsformation. only sourse and destination. each time only 7000 recotds were insterd into target table You stated "i am using oledb sourse and destination. for loading 3 Core recods" however you now state 7000 records were inserted. Could you please provide a little more detail about what it is you are doing.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 2:44am

I have two servers. i move data from one server to another server. i was createing package with sourse and destination oledb. each time only 7000 records were inserted. it took 30 to 40 mints for loading 3 core records.
May 16th, 2011 2:47am

no Trnsformation. only sourse and destination. Just checking: have you used fastload option in the destination?Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 2:49am

yes. i was used fastload option. but its took 30 to 40 mints time for loading data.
May 16th, 2011 2:55am

Copy the package and replace the destination component with row count to check how much time package is taking to read the data from source server.Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 4:33am

I have two servers. i move data from one server to another server. i was createing package with sourse and destination oledb. each time only 7000 records were inserted. it took 30 to 40 mints for loading 3 core records. What are "core records"?MCTS, MCITP - Please mark posts as answered where appropriate.
May 16th, 2011 5:50am

What are "core records"? Koen, I think Vamsi is refering to 10 million records by 1 core. Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2011 6:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics