Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Executing a package with DTSRUN
Message
From
09/03/2000 15:36:47
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Executing a package with DTSRUN
Miscellaneous
Thread ID:
00343831
Message ID:
00343831
Views:
51
I've created a DTS package that runs fine except when I call it from a job using DTSRUN /Smyserver /Usa /Nmypackage.

The job fails because DTS seems unable to find the server, although the package itself runs fine.

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147008507 (80074005) Error string: Unspecified 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: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 1100 Error: -2147467259 (80004005); Provider Error: 6 (6) Error string: [DBNMPNTW]Specified SQL server not found. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Next
Reply
Map
View

Click here to load this message in the networking platform