all groups > sql server dts > february 2005 >
You're in the

sql server dts

group:

Timeout on a task?


Timeout on a task? Cristof Falk
2/19/2005 8:43:22 AM
sql server dts: 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.

Re: Timeout on a task? Cristof Falk
2/20/2005 10:01:47 PM
Any ideas on this, please? Need to solve this on Tuesday, and I'm at a
loss. Thanks!

In article <MPG.1c810c81b9231fb8989684@msnews.microsoft.com>,
cristoff@charter.net says...
[quoted text, click to view]
AddThis Social Bookmark Button