February 11, 2011 at 11:42 am
I need to migrate/copy a bunch of packages stored in MSDB from one server to another. I don't have all these packages in BIDS project, otherwise I would do a deployment from there.
I don't want to do them one at a time, as this would be time consuming. Any suggestions?
February 12, 2011 at 5:58 pm
Hi String,
This is most likely going to involve scripting. Powershell is probably your first best choice but I don't know enough Powershell to help you. You can also do this with an application. If you're running SSIS 2008, the packages are stored in msdb.dbo.sysssispackages. If you're running SSIS 2005, I believe (it's been awhile) the packages are stored in msdb.dbo.sysdtspackages90.
I recommend considering two things:
1. Source control; and
2. Executing and managing SSIS packages from the file system.
Hope this helps,
Andy
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics
February 14, 2011 at 1:09 am
You can also script out dtutil to move packages from one server to another.
http://msdn.microsoft.com/en-us/library/ms162820.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply