June 18, 2012 at 10:17 am
SSIS 2008 R2
I have 15 packages in an SSIS solution. I am currently working on one package. I need to build/rebuild this package only, not the whole solution. How would I do that?
Thank you.
June 18, 2012 at 12:02 pm
Create a new solution. Add Existing Package to the new solution. Build the package.
The last time I checked, Build doesn't work properly without a solution and it does, as you've noticed, build everything, not just a single project / package. Tis annoying.
June 18, 2012 at 12:28 pm
Thanks, Brandie.
does it mean that in this new solution I'll need to rebuild all supporting objects like datasources, smtp managers, referenced packages etc? Or I could be able to reference the ones in my original solution?
Thanks,
June 18, 2012 at 12:33 pm
Sergei Zarembo (6/18/2012)
does it mean that in this new solution I'll need to rebuild all supporting objects like datasources, smtp managers, referenced packages etc? Or I could be able to reference the ones in my original solution?
Is this an SSIS package or an SSRS item?
An SSIS package contains all its connection managers and such within the individual package, unless you're calling another package within the package.
An SSRS report often has datasources and such that exist outside of the package.
If the later, you need everything. If the former, you should just be able to stick the package in a new solution without a problem. Unless you're calling a package within your package. The only way to know for sure is to try it, though.
June 18, 2012 at 12:40 pm
it is an SSIS package, and yes at times I call a child package from within a parent one.
Thank again for your help. It seems you showed me a way to build a standalone pkg and save time on this.
June 18, 2012 at 12:42 pm
I'm glad I could help. Let me know if you need any other info on how to do this.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply