by I have a problem with DTSRUN in SQL Server 7.0. In a Datawarehouse solution
for our customer we use the DTSRUN utility to start our DTS packages from
Access. We load data from AS/400 to SQL 7 by using IBM Client Access.
The problem:
After a serverupgrade (where SQL7 is running) to cluster server, the DTSRUN
utility stopped working. The DTS package(s) can execute manually from
Enterprise Manager without any problems. We have upgraded SQL7 to SP1
without any luck. The DTSRUN command has been tested outside of Access, no
improvement! The user Eko (NT user) is the owner of the DTS packages and the
table importing to. No package password is used.
The command line for the DTSRUN utility is as follow:
DTSRUN /S UFA-SQL /E Eko /N DTS_Ladda_Konton
The error log doesnt give me much to go on, but here it is:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_{D4288651-A3B2-11D2-87BB-00C04F674466}
DTSRun OnFinish: DTSStep_{D4288651-A3B2-11D2-87BB-00C04F674466}
DTSRun OnStart: DTSStep_{D428864A-A3B2-11D2-87BB-00C04F674466}
DTSRun OnError: DTSStep_{D428864A-A3B2-11D2-87BB-00C04F674466}, Error
= -2147008507 (80074005)
Error string: Odefinierat fel (=undefined error)
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 1100
Error Detail Records:
Error: -2147008507 (80074005); Provider Error: 0 (0)
Error string: Odefinierat fel
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 1100
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: [IBM][Drivrutinen Client Access ODBC (32-bitars)]Allm?nt
fel. (=common error)
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file:
Help context: 0
DTSRun OnFinish: DTSStep_{D428864A-A3B2-11D2-87BB-00C04F674466}
DTSRun: Package execution complete.
Has anyone encountered this problem? I am gratefull for any suggestions.
Regards,
Per Ivars