DTS ERRORS when run with dtsrun

DTS ERRORS when run with dtsrun

Post by mark » Sat, 26 Aug 2000 04:00:00



I am getting a sql error when starting a dts package from a 2nd server.

SqlDumpExceptionHandler: Process 13 generated fatal exception c0000090
EXCEPTION_FLT_INVALID_OPERATION. SQL Server is terminating this process.

The package runs fine when started from the sql server itself.

The id used to start the dtsrun is
an administrator on both servers.

The sql server is 7.0 dual processor proliant 6400.

 
 
 

1. Error running DTS Package using DTSRUN

I am trying to run a DTS package from the command line using xp_cmdshell and
DTSRUN and I'm getting the following error message:
____________________________________________________________________________
_______________
Error:  -2147217900 (80040E14); Provider Error:  14262 (37B6)
Error string:  The specified DTS Package ('Name = 'DTS_CCNew'; ID.VersionID
=  {[not specified]}.{[not     specified]}') does not exist.
Error source:  Microsoft OLE DB Provider for SQL Server
Help file:
Help context:  0
____________________________________________________________________________
_______________

I have the DTS Package saved as a Local Package and as a Respository
Package.

I had this working on another SQL Server so I'm alittle lost and can't find
much data on this error.

Thanks for any help.

- lise

2. Syntax Error

3. Errors not raised when DTS package run with DTSRUN

4. FPW2.6 - Print destination

5. DTS Running DTSRUN Using the NT Scheduler causes Error

6. Primary Key/Unique Key?

7. DTS Package scheduled and/or run with DTSRUN

8. Stupid question

9. Looking to run a dts with dtsrun

10. Running a DTS Package from a command line with DTSRUN

11. running a DTS package from dtsrun

12. DTSrun: Unable to RUN DTS packages from a job

13. !!!How to run DTS package using dtsrun command