Hello,

I am getting general errors in my log file (intermittently) of 80074005 and
80004005 "Unspcecified Error" when I run nightly DTS packages. The error,
as I mentioned does not happen all of the time and if I execute the package
manually, it runs fine. I am connecting to a couple of other data bases that
are accessed through a VPN and there is a firewall involved. The data bases
that I am connecting to are Informix and native SQL through linked servers on
a SQL 2000 server on my end. I connect to the Informix data base with an
OpenLink ODBC driver and the SQL data base with the native SQL server ODBC
driver. I don't think it is the ODBC drivers since it happens with both of
the data pulls (DTS packages) and they are different drivers being used. The
fact that it does not happen all of the time is what is hard to troubleshoot
and sometimes, it seems that it maybe drops a connection halfway through the
data pull. Do you have any ideas?

Thank you so much for any help at all, I am pulling my hair out on this one!

Hi Patrice,
are you tried to raise a profiler trace in order to see further details?

If I understand well, you have a dts which read data from Informix and load
them into Sql Server tables . It could be that Informix Db were suffering
issues such as backups or bigger jobs in these moments?

regarding these errors, I suppose that it info extracted from the general
log.. if that DTS have pump tasks are you tried to have a look for the
information provided by the exception file for that transformation??
-
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''s hard to provide information
without seeing the code. location: Alicante (ES)


"Patrice" wrote:

Hello Patrice,

The error 80004005 could very well indicate that you have lost contact with
a data source somewhere. Maybe the VPN drops or the firewall refuses you.
This would explain the intermittent nature and why you can run it.

Have the network admins monitor the network segment when you are running
these jobs and then when you get a failure you can compare notes.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com