[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

11/05/2009 at 06:01AM PST, ID: 24874375 | Points: 500
[x]
Attachment Details

How to update SSIS package template

Asked by shekhar_sudhanshu in SSIS

Hello Experts,

In my project, we use a standard template for SSIS package development. This template contains some common variables, connection managers, etc that are constant across all the packages in the project. Every time for a new SSIS package, we just copy the template, generate a new ID for it, do the additions required and save it.

Let's say, we need 200 packages in total. When the development is half way done, we identified that there needs to be some change in the template. Off course, for the remaining 100 packages we will use the new version of the template, but what about the already made 100?

Do we have to manually change in all the already developed 100 packages, or is there a way out?

What I can think of is, using .NET code, we can actually go inside those package's xml code and do the necessary addtion/modification/deletion. Can somebody provide the code to do this? Also, Is there an alternate way to do this?

Thanks,
Sudhanshu.
[+][-]11/08/09 01:58 AM, ID: 25769974

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/08/09 10:34 PM, ID: 25773745

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/08/09 10:46 PM, ID: 25773790

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-91 - Hierarchy / EE_QW_3_20080625