I have a DTS package which imports data to SQL Server from DB2 v5 tables.
I'm dealing with that well known problem: when executed manually, the package goes ok. When executed as a job, the package fails, with a non friendly error message. The DB2 base is read through
Yes, I'm executing the package manually using the same acount of SQL Server Agent.
I'm accessing the DB2 base using ODBC drive (the data source type in the DTS Connection is "Other (ODBC Data Source)). The SQL is SQL 2000 with SP3.