October 25, 2007 at 2:30 pm
Hi
I open DTS Designer of DTS packages in Source Server there is one option called "SAVE AS" By using that option I save DTS packages in Destination location,
but I taken locals as "SQL Server" which is Default.
Is it ok, after that what I have to do to make sure DTS packages are copied properly
Note:My Database in Destination Server is READ ONLY mode.
Help me regarding
October 25, 2007 at 5:09 pm
You need to enter the destination server name and the appropriate credentials. The packages are saved in the msdb database, which should never be read only.
October 28, 2007 at 1:50 pm
[font="Courier New"]You can do the following
$) Open the DTS in source server
$) Save the DTS as structured storage file (i.e dtsname.dts)
$) Copy the file to the destination server
$) Right click on the Data transformation services folder & open the package
$) The file save as, select sql server, provide server name and authentication mode to save the DTS in destination.[/font]
Regards..Vidhya Sagar
SQL-Articles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply