Want to deploy msdb pkgs from one server to another server msdb

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ashish Kumar Mehta » Want to deploy msdb pkgs from one server to...

Want to deploy msdb pkgs from one server to another server msdb

Rate Topic

Display Mode

Topic Options

Author

Message

prudhivi9

Posted Wednesday, July 04, 2012 5:26 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, August 16, 2012 12:11 AM
Points: 16, Visits: 47

Hi All,

Actually we are working with two servers,
my requirement is like this,
i want to copy packages from server A msdb to Server B msdb.
Am having many number of packages in my server A msdb.
so i want to copy all the packages at a time.
Can any body gimme an idea to do it.

Appriciate the response.

Thanks,
Quest.

Post #1324946

rhythmk

Posted Wednesday, July 04, 2012 6:10 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603

prudhivi9 (7/4/2012)

Please have a look on below link.

http://www.sqlservercentral.com/Forums/Topic530477-1329-1.aspx

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Smile

Post #1324977

prudhivi9

Posted Wednesday, July 04, 2012 6:22 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, August 16, 2012 12:11 AM
Points: 16, Visits: 47

Hi,
I jst followed the link wh u hav specified there,
but one thing is like how to create a batch file for all the packages, can i get any syntax for that.

Thanks for rply
quest.

Post #1324984

rhythmk

Posted Wednesday, July 04, 2012 7:02 AM

Old Hand

Group: General Forum Members
Last Login: Saturday, November 10, 2012 9:30 AM
Points: 388, Visits: 603

prudhivi9 (7/4/2012)

Hi,
I jst followed the link wh u hav specified there,
but one thing is like how to create a batch file for all the packages, can i get any syntax for that.

Thanks for rply
quest.

Below is for moving one packages.

dtutil /FILE <name>.dtsx /DESTSERVER SQLServer /COPY SQL;<name>

OR

dtutil /MOVE SQL;destPackage /SQL srcPackage /SOURCEUSER srcUserName /SOURCEPASSWORD $Hj45jhd@X /DESTUSER destUserName /DESTPASSWORD !38dsFH@v

Likewise you need to put all in a for loop.

However I got one more solution for you hope that also work.

1. Open MS Visual Studio, and create a new Integration Services project if you already don’t have one.

2. In the solution Explorer under SSIS packages - right click on the folder – Add existing packages (add original packages)

3. Right click on the project – Property. Specify the output path for your build. Click on Deployment utility and set “Create DepoloymentUtility” to true. Specify the output Path. Click OK.

4. Right click on the project – Build. The packages with a deployment utility should be under the directory specified in step 3.

5.Copy the entire deployment folder and paste it to the server you want to move the packages to.

6. Log in to the server and navigate to the directory made in step 5. Double click on the xxx.SSISDeploymentManifest file to initiate the deployment wizard.

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Smile

Post #1324999

« Prev Topic | Next Topic »

Permissions