Saturday, September 14, 2013

Moving DTS packages from one server to other server

http://www.sqlservercentral.com/Forums/Topic697546-146-1.aspx

INSERT INTO msdb.dbo.sysdtspackages
SELECT *
FROM OPENDATASOURCE('SQLNCLI','Data Source=ServerName;Integrated Security=SSPI').msdb.dbo.sysdtspackages


--------------------------------------------------------------------------------

No comments:

Post a Comment