I have some DTS packages developed in SQL 2000 to import data from CSV file to SQL db. Now the database is restored in SQL 2005. when I run those dts packagse from Store Procedure with xp_cmdshell command it shows me error, DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied I also changed the connection string from udl file to new database of sql 2005. Is it problem of dts version? Is there something I am missing ? Does I need to upgread the dts or its works without upgreadation? Please suggest any solution.Thanks & Regards, Vyankatesh Mujumdar

Is xp_cmdshell enabled on the new server, by default it's disabled on SQL 2005. Execution of DTS packages is possible in SQL 2005 but they should be migrated to SSIS (no autoupgrade or something). Check: http://axel8s.wordpress.com/2011/03/28/bcp-through-clr/ for an alternative. RegardsAxel8s http://axel8s.wordpress.com

Check the Service Account by which you are running the DTS Package. Or, can you get into the Package design and make sure that DTS can even see the database?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Yes the xp_cmdshell is enable I run the follwong query to do this EXEC master.dbo.sp_configure 'show advanced options', 1 RECONFIGURE EXEC master.dbo.sp_configure 'xp_cmdshell', 1 RECONFIGURE Is it mean that I cant use sql 2000 DTS packages directly on SQL 2005 db? Thanks & Regards, Vyankatesh Mujumdar

When I open one dts package in SQL 2005 it have one connection manager. Is every dts package have seprate connection manager? is that like I have to change the connection from connection manager from every dts file? Thanks & Regards, Vyankatesh Mujumdar

Your natural path supposed to be upgrading the packages to SSIS 2005. You can however run the DTS (old engine) packages in SQL 2005. Please read SQL Server 2005 Integration Services Backward Compatibility http://msdn.microsoft.com/en-us/library/ms143706(SQL.90).aspx You most probably have to install Microsoft SQL Server 2000 DTS Designer Components from http://www.microsoft.com/downloads/en/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en You can run DTS packages as follows: How to Configure and Run DTS Tasks with SQL Server 2005 To run the DTS tasks in SQL Server 2005 1. Click Start, point to Programs, point to SQL Server 2005, and then click SQL Server Management Studio. 2. In the Object Explorer pane, expand the Management node, and then expand the Legacy node. 3. The Data Transformation Services node opens in the right pane. From here, you can run the DTS and data management tasks.Arthur My Blog