Post reply

copying DTS packages from one server to another

  • June 25, 2003 at 9:32 am

    #76027

    Hi,

    I remember seeing an article about copying DTS packages from one server to another by directly modifying the msdb table. Can anyone point me to the article please? Also, how do you handle DTS package logging. Do I update the same table but on a different column?

    Please advise.

    Sang Nahm

  • June 25, 2003 at 9:47 am

    #463061

    Here you Go

    http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

    Shas3

  • June 25, 2003 at 9:51 am

    #463065

    Alternatively you can use the following one to copy single DTS Pack

    Go to Enterprise manager -> Data Transfermation services -> Select the package -> Open the package -> In the menu select Package/Save As -> Specify the Server name and the rest

    Shas3

  • June 25, 2003 at 12:37 pm

    #463114

    Thanks.

    I remember an article or script posted within past two weeks that said that we can modify one of the systable in msdb database under 'source' something column.

    I thought I saved it, but didn't.

    Thank you for your reply.

    quote:

    Alternatively you can use the following one to copy single DTS Pack

    Go to Enterprise manager -> Data Transfermation services -> Select the package -> Open the package -> In the menu select Package/Save As -> Specify the Server name and the rest

  • June 26, 2003 at 6:34 am

    #463213

    To copy all DTS Packages, there is an SQL Server add on tool(DTSBackup), that you can use to script all DTS's then copy over theses script and run them on the target server.

    Remeber all DTS are stored in msdb.

    Thanks

  • June 26, 2003 at 2:53 pm

    #463349

    Very good Article on Moveing DTS Pack

    http://www.sqldts.com/default.aspx?6,105,204,0,1

    Shas3

  • June 26, 2003 at 3:05 pm

    #463352

    Thank you all so much.

    All your refernces are quite helpful. I remembered the article to which I was referring was about moving jobs and changing orginating_server column in case any one was wondering what I was talking about.

    Again thanks kindly.

    Sang

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply