June 26, 2008 at 11:31 am
I wanted to migration all the SSIS package to different Server. In order to move SSIS package to different server, can I copy MSDB database, if so then what will happend to the existing MSDB objects. Or can I append MSDB database into existing MSDB database.
any help will be appreciated.
June 26, 2008 at 11:44 am
to Copy package stored in MSDB.
dtutil /SQL PAckageName /COPY DTS;PackageName
Package stored as file system;
dtutil /FILE c:\myPackages\mypackage.dtsx /COPY FILE;c:\myTestPackages\mynewpackage.dtsx
checkout more here: http://msdn.microsoft.com/en-us/library/ms162820.aspx
Maninder
www.dbanation.com
June 26, 2008 at 11:54 am
Thanks Mani,
It will copy only one ssis package at a time. What if I have 100 SSISI package. Can I move MSDB database to another server to copy all the ssis package.
June 26, 2008 at 12:01 pm
Check the link http://msdn.microsoft.com/en-us/library/ms365338.aspx
June 26, 2008 at 12:05 pm
I am not sure, how to do a BULK Load.
Only if you have all you packages under one Project.
Or you can create a batch File with the DTUTIL.
Have you checked your package Configuration? Is it portable i.e. have you defined a configuration File for the connection properties. Else it would be be a eventful experience, move those 100 packages.
Maninder
www.dbanation.com
June 26, 2008 at 12:13 pm
As I said in my previous post check also the link
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22009002.html
just take time to do it.
June 26, 2008 at 12:18 pm
I think Ahmed misunderstood the previous reply, it was Mani not me, we both are singh that is why you got confused.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply