Re: Timeout on a task?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Cristof Falk (cristoff_at_charter.net)
Date: 02/21/05


Date: Sun, 20 Feb 2005 22:01:47 -0800

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...
> 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.
>



Relevant Pages

  • Timeout on a task?
    ... We're using VB6 to use Automation to write a DTS package in memory, ... execute it, and remove it. ... with SQL Server 2000 as the destination. ... For smaller feeds that process faster, ...
    (microsoft.public.sqlserver.dts)
  • RE: Resultat in eine Textdatei speichern
    ... Destination wählen ... Nun hast du ein DTS Package, ... hier hinein das gleiche SQL von der Prozedur genommen. ...
    (microsoft.public.de.sqlserver)
  • Re: How do I dynamically change output text file properties?
    ... The procedures extract the data and I can individually create a DTS package ... of a destination source when that source is a SQL Server table, ... You can use a dynamic properties task to browse a text file ...
    (microsoft.public.sqlserver.dts)
  • Leading Zero Is Dropped
    ... I have a DTS package that has an Excel spreadsheet as the source and SQL ... Server database table as the destination. ... Some zip codes have leading zeros but when using a simple Copy Column ...
    (microsoft.public.sqlserver.dts)
  • Variable text file destination name
    ... I have a DTS package that creates a series of text files ... Text File (Destination) Connection ... I can dynamically change all other types of ...
    (microsoft.public.sqlserver.dts)