August 21, 2010 at 10:32 am
How can i move all stored pkgs from one server to another, i have few 100's and looking for an easy way to do.
August 21, 2010 at 11:39 am
You may find DTUTIL useful. Here is an example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 22, 2010 at 11:09 pm
have you stored all packages in msdb database or on server as file?
[font="Verdana"]--www.sqlvillage.com[/size][/font]
August 23, 2010 at 7:04 am
all pkgs are saved in msdb and i am looking for an easy way to move them to another server.
August 23, 2010 at 11:56 pm
Hi,
As suggested by ADIGA, use DTUTIL.
August 24, 2010 at 2:51 am
use DTUTIL, Here is the link with an example.
August 24, 2010 at 12:15 pm
I think we have agreement on using DTUTIL....:-P
August 24, 2010 at 12:32 pm
The link provided is a good example on how to use DTUtil.
You could also run a query to select the most recent version of that package from sysdtspackages90 (sql 2005) or sysssispackages (sql 2008), use an ssis package and copy the package to the new server (a method I have used in the recent past).
Just a thought.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply