April 15, 2002 at 6:55 am
I have a database on sql 2000 win 2k . The process is that the customer. donwloads the data from server makes the changes and DTS's the data to server. thats around more than 50000 records. And the result he gets is time out. Wat is the solution for this .? Any other ways to copy such huge data.
brij
April 15, 2002 at 7:01 am
I have moved serveral million records is a single pacakge execution and have never seen this. If is an app the app may be having a problem finding the DTS package within the timeout period, if the DTS package itself is returning this then the datasource may not be returning within the timeout range. Can you give more spefici details about how your package works, is executed, connection parameters in it, and how quick the return occurrs.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 15, 2002 at 11:32 pm
surprisingly it times out after 16 minutes..Even i have not encountered time out in dts. And its done through DTS wizard. not a application or something
April 16, 2002 at 5:16 am
Take a look here and see if any of these KB Articles on the MS KB Site fit you problem. http://search.support.microsoft.com/search/default.aspx?Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=sql&Query=dts%2520AND%2520timeout&Queryc=dts+AND+timeout&withinResults=false&srchstep=0&KeywordType=BOOLEAN&Titles=false&numDays=&maxResults=25.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply