Hello,

I have a DTS package that I have created to move data from an Informix
database to a SQL Server 2000 system. I'm using ODBC for the link to
Informix. My SQL Server 2000 is SP4 - "Microsoft SQL Server 2000 - 8.00.2039
(Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft
Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack
1)"

The DTS package is scheduled to run hourly. More often that not, there is a
specific copy transform that fails, copying the contents of one table in
Informix to a staging table in SQL Server. There are actually five tables
that are copied at once, and I typically have this problem with one or two of
them, but not the others.

The problem is this: mostly, but not always, the copy transform fails with a
column not found error. It's always the first column in the select statement.
I decided I didn't really need that column and removed it from the select
statement, and then it would fail because it couldn't find the second column
in the select statement. But 30% of the time it runs fine with no changes
whatsoever to the package.

The exact errors are these:

- when the package is being run, "1 task(s) failed during execution."
- when double clicking on the step with the red X, "Column name 'theColumn'
was not found."

Why is this running so inconsistently?

Thanks.

- Michael