Transferring SSIS packages

• imani_technology

  SSCrazy Eights

  Points: 8200

  More actions

  May 5, 2008 at 4:56 pm

  #121289

  I have several SSIS packages under the MSDB folder. I need to transfer those packages to another database on another domain, and there is currently no shared drive between the domains, so I can't use the file system. Is there a way to transfer or copy all those packages that are under MSDB? I see those packages in the sysdtspackages90 table. Could that help somehow?

• Frank Bazan

  SSCertifiable

  Points: 5378

  More actions

  May 6, 2008 at 9:10 am

  #811283

  Try dtutil.exe There are more instructions on how to run it on BOL...

  Command will look something like this:-

  dtutil.exe /SourceS SourceServerName /SQL PackageName /DestS TargetServerName /MOVE SQL;/FolderName/PackageName

  Kindest Regards,

  Frank Bazan