Dynamic SIS package changing source connection at run time

Question

0.00/5 (No votes)

See more:

Hi All,

I am in between of creating a dynamic SSSIS package which will run for multiple zones having different source connection.
My source is in Oracle.
I am having 3 DFT with the 3 different source tables.
I want to create a package with above DFT dynamically so that my single package can run for the entire zone with dynamically source connection change.
I have created a Master table which stores the zone source connection string and zone name.
so if in future any new zones come so only newly zone details need to be add in master table without opening the package.
Please suggest me the better approach to achieve the above scenario.

In attached file you can see the ETL package design

Thanks & Regards,
Vipin Jha

Posted 30-Jul-15 1:48am

vipinjha

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

virusstorm · Answer 1 · 2015-07-30T06:41:00

The dynamic support in SSIS never really impressed me, but you need to consider the type of user it was geared towards, non-developers.

Take a look at this post, it should help you get started with this:
SSIS Dynamic Connections[^]

In the past, I've also wrote C# scripts that do similar manipulation, but I wasn't really impressed with that route either. Here is a YouTube video that demos it:
Introduction to C# Scripting in SSIS[^]

If you are using SQL Server 2012 and higher, I would suggest taking a look at this:
SSIS 2012 Projects: Deployment Configurations and Monitoring[^]

If your packages are identical or generic enough, you might be able to make of environments.