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

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

no Trnsformation. only sourse and destination. each time only 7000 recotds were insterd into target table

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

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.

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

yes. i was used fastload option. but its took 30 to 40 mints time for loading data.

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

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.

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