dbTalk Databases Forums  

Timeout on a task?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Timeout on a task? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Cristof Falk
 
Posts: n/a

Default Timeout on a task? - 02-19-2005 , 10:43 AM






I'm having an issue that looks suspiciously like a timeout on a task.
We're using VB6 to use Automation to write a DTS package in memory,
execute it, and remove it. This is a flat, fixed format, file as a
source, with SQL Server 2000 as the destination. The file in question is
about 2.5GB in size.

When it gets to 60 minutes in processing, I get the "error: method '~'"
error. There might be a valid message except the resource files had been
in the wrong place (as we're distributing the DTS runtime). There are a
portion of records in the destination table.

I've googled, and am not finding anything promising.

For smaller feeds that process faster, it works fine.

One other thing of ntoe is that, once it fails, I have to log out of
Windows and log back in for any feeds to work properly without
immediately giving that error.

Any ideas, please? I'm really confused on this.

Thanks.

Reply With Quote
  #2  
Old   
Cristof Falk
 
Posts: n/a

Default Re: Timeout on a task? - 02-21-2005 , 12:01 AM






Any ideas on this, please? Need to solve this on Tuesday, and I'm at a
loss. Thanks!

In article <MPG.1c810c81b9231fb8989684 (AT) msnews (DOT) microsoft.com>,
cristoff (AT) charter (DOT) net says...
Quote:
I'm having an issue that looks suspiciously like a timeout on a task.
We're using VB6 to use Automation to write a DTS package in memory,
execute it, and remove it. This is a flat, fixed format, file as a
source, with SQL Server 2000 as the destination. The file in question is
about 2.5GB in size.

When it gets to 60 minutes in processing, I get the "error: method '~'"
error. There might be a valid message except the resource files had been
in the wrong place (as we're distributing the DTS runtime). There are a
portion of records in the destination table.

I've googled, and am not finding anything promising.

For smaller feeds that process faster, it works fine.

One other thing of ntoe is that, once it fails, I have to log out of
Windows and log back in for any feeds to work properly without
immediately giving that error.

Any ideas, please? I'm really confused on this.

Thanks.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.