Redeploy (overwrite) to MSDB

Question

Post reply

Redeploy (overwrite) to MSDB

Shaira

SSCrazy

Points: 2432
More actions
September 17, 2010 at 9:05 am

#145188

Good morning all,
I deployed my SSIS packages to MSDB and all has been running fine until … I needed to edit one of my packages so I opened it and changed it in BIDS and then “Saved a copy of xxx.dtsx AS …” back into MSDB. It asked me if I wanted to overwrite and I said Yes, however the changes did not take effect the next time my job ran. I’ve looked at msdb.dbo.syssispackages but it only tells me when the package was created, there is not an amended date or version.
I am obviously missing a step somewhere; how do I redeploy (overwrite) an existing package stored on MSDB with my current changes?
TIA!!
Using SQL/SSIS 2008 ~

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

prasadinpatni Old Hand Points: 344 More actions · Answer 1

Dude,

whatever changes you make to package,follow the steps given below.

1) Go to Solution Explorer and Re-Build the solution.

2) Deploy the package to SQL Server using manifest file and all the changes done will be reflected i.e Overwritten.

3) Execute the package from SQL Server.

Shaira SSCrazy Points: 2432 More actions · Answer 2

Thanks, but the manifest file deploys all packages in the project, I'm looking for a way to redeploy just a single package from my project and completely overwrite what's currently in MSDB. Is there a way to delete the package in the MSDB and then just do a new "Save Copy of xxx.dtsx AS ... "?

prasadinpatni Old Hand Points: 344 More actions · Answer 3

No.you can delete the packages in the project and rebuild and deploy..

Ex: i have 5 pkgs in a project and i dont want 1 package.i'll delete it and redeploy..so that my MSDB will have only 4 pkgs.

remember,when you deploy the number of packages in your project reflect the no of pkgs in MSDB..

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Connect with SSMS to Integration Services and locate your package. Right-click, select Delete.

Then deploy your package again from BIDS.

You are right about the fact that you can only see the creation date, but you can always check the version numbers to see which is the version in MSDB.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sequelsurfer SSCrazy Points: 2562 More actions · Answer 5

I have to say that I didn't have any issues overwriting dtsx packages in MSDB. I rebuilt the solution once the changes had been made and then selected Import Package from Stored Packages >> MSDB in Object Explorer. Never failed to overwrite. May not have been the best solution ever but it worked for me a while back.

Now working on implementing one touch deployment as described/shown in a tech ed video that I found really informative, anything to improve deployment has got to be useful.

Here's the link for anyone interested.

http://blogs.msdn.com/b/mattm/archive/2010/07/03/ssis-configuration-and-deployment-videos.aspx

Shaira SSCrazy Points: 2432 More actions · Answer 6

Thanks everyone for your input - I think I've got it now.