SQL Server Performance

How to make use of exported JOB,ALERTS and DTS packages

Discussion in 'SQL Server DTS-Related Questions' started by sqldba_ind, Oct 24, 2007.

  1. sqldba_ind New Member

    Hi all
    I moved the Database from One server other Server
    now Database in READONLY mode.
    Now I exported JOB,ALERTS and DTS packages nad users also which are working for that Database.
    Is it enough Exporting DTS packages or I need to do some thing more to make use of those DTS.
  2. sqldba_ind New Member

    Hi satya I am expecting response from your end. Off course every expecting repay from your end.Finally moved DTS packages to my Destination Server.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.
  3. satya Moderator

Share This Page