DTS Transition | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Transition

We just moved our SQL Server from one server to another, however, when we try to run our DTS packages that we moved over, we get an error stating "Cannot open a log file of specified name. The device is not ready." Have I incorrectly transferred the packages or do they need to have a setting changed? Thanks in advance! Our method of moving the DTS packages from the old server to the new one was to follow these instructions: 1 Create a new package, and add two connections, one for the source server and one for the destination server. 2 Select the two connections and add a DataPump (Transform Data) task. 3 SQL Server 2000
Do not open the DataPump task properties yet. First open Disconnected Edit from the package menu. Navigate to your DataPump task and set the SourceObjectName and DestinationObjectName properties to [msdb].[dbo].[sysdtspac kages]. Now open the DataPump task properties and go to the Transformations tab to allow the transformations to auto-generate. In SQL Server 2000 you no longer have the ability to manually enter a table name for the source or destination object as in SQL Server 7.0, but this method allows you to overcome this as described. 4 You can now execute you package. –fromhttp://www.sqldts.com/default.aspx?204 Joe Janka
Check: http://www.microsoft.com/technet/itsolutions/cits/mo/smc/nwf05.mspx http://www.microsoft.com/technet/prodtechnol/sql/70/reskit/part7/sqc09.mspx Luis Martin
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
I guess dts log file is defined to point to the file on the path that exists only on computer where package is created but doesn’t exist on the server.