DTSRUN error in SQL7

DTSRUN error in SQL7

Post by Per Ivar » Thu, 18 Nov 1999 04:00:00



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

 
 
 

1. dtsrun.exe doesn't run in SQL7.0 but run fine in SQL2000

Hi,

I am trying to setup a job to run DTS using DTSrun
utility.  I tested in SQL2000, it was fine, but in SQL 7.0
I have this error "DTSRun: cannot create COM Server to
load and execute DTS Package - Error -2147221164(80040154)
Class not registered".

Any one know the reason why.  Please help.

Thanks a lot.

Tina,

2. COM-Gen 2000 feature update

3. DTSRun.exe does not run in SQL7.0

4. signed servlets

5. Restore DB from NT-SQL7 to WIN98-SQL7 error

6. D3 Objects On VB

7. Linked Server error SQL7 to SQL7 OPENQUERY VS Direct

8. free tool for query, desc

9. dtsrun 'could not lock file' error

10. strange xp_cmdshell "Dtsrun ......" timeout error

11. Error detection - using DTSRUN.EXE in a Windows batch file

12. dtsrun utility error - URGENT!!!

13. DTS ERRORS when run with dtsrun