July 4, 2010 at 5:13 pm
Hello Everyone
I know the approach of deploying a package and executing them. But what if we want to deploy multiple say 50 different SSIS packages to target server with package configuratiions and how to execute them.
Do we need to deply them one after the other manually or can we do it some other way.
July 4, 2010 at 9:48 pm
Check out Sean McCown's recent presentation from 24 hours of PASS where he goes over deploying packages via powershell http://www.sqlpass.org/LearningCenter/24Hours.aspx
July 5, 2010 at 8:50 am
How about putting those packages in a single master package by using execute package task and then deploy that single master package...will that work
July 6, 2010 at 8:51 am
ravimodi (7/5/2010)
How about putting those packages in a single master package by using execute package task and then deploy that single master package...will that work
I would have to recommend against this approach, while 50 packages mat be a lot it is not outrageous and combining them into a single package would liekly yield a HUGE package that debugging would be problematic.
A better method is to use either PowerShell or use command scripts and the DTUtil.exe. I have successfully used the latter method with great success.
CEWII
July 6, 2010 at 2:39 pm
We use BIxPress http://www.pragmaticworks.com/Products/Business-Intelligence/BIxPress/Default.aspx
Try it. We use it a lot. You can deploy packages in bulk, create templates, send e-mails, monitor SSIS execution in graphical mode!...
Every developer in my group has it.
Jacob Milter
BIA
Database Manager
UPS
Jacob Milter
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply