I have been using this same stored procedure to execute DTS packages with
one machine. (MSSQL 7 with service pack1) I have migrated everything to
another machine where the DTS package was remade and runs fine alone.but
when called by the stored procedure gives the error message below.
Everything else seems the same to me on the two machines except the name of
the server. Does anyone have a sense of what gives? Thanks. David Klass
AS
/******************************
** Name: sp_Run_DTS
** Desc: Run a DTS Package
**
** Parameters: DTS name
**
**
** Auth: XXXXXX
** Date: XX/XX/XX
******************************
** Change History
******************************
** Date:
** Author:
** Description:
******************************/
--S is the server name
--E is Trusted connection or you can use
--P password and
--U username
--N is the name of the DTS
Error: -2147467259 (80004005); Provider Error: 52 (34) Help context: 0 Error: -2147467259 (80004005); Provider Error: 52 (34) Error string: [DBNMPNTW]ConnectionOpen (CreateFile()). Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0
*****************************
sp_Run_DTS 'DTS__DrugLoader' --trying to run the command
****************************
output
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------------------------------------------------------
---------------------------
DTSRun: Loading...
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: 713
Error string: Client unable to establish connection
Error source: Microsoft OLE DB Provider for SQL Server
Help file: