Re: SSIS data load issue

OK

Do you get any errors?
Is it just slow?
Where is the data? Is it local to you?
What does the progress tab say? anything? Is it warning you about not using columns and it could be faster if you did?



--


Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com



"gaurav" <gaurav@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:BA047AEA-7469-4CE1-BC99-5A4636716CB0@xxxxxxxxxxxxx:

I'm new to SSIS in SQL 2005 but i have done good work in DTS before. I'm
working on a simple data load process between 2 different SQL srv 2005
databases. the problem is that i need to transfer around 50K records at a
time. When i run my package from Visual Studio 2005 it takes ages and even
never completes and errors out but i remember in DTS we use to load same sort
of data without any issue. Please advice me if i'm doing something wrong? or
advice me the better way of loading bulk records. I have around 9million
records to be moved to different tables. And at present i can't see any
solution. Any help is much appreciated. Thanks in advance.

.

Loading