I’d like to be able to call different packages from a control flow. These packages will have different requirements for parameters therefore I’d like to create them dynamically.

Is this possible? Can I do it using a script task?

Thanks in advance.

Ben

Report Abuse

Today, 12:17 PM UTC

Eric Wisdahl

Answerer

Posts 591

Re: Is it possible to dynamically create multiple variables in a package?

Was this post helpful ?

What you’re asking are two very different questions, both of which have the answer of yes but only one of which is easy.

You can call different packages from the control flow, use the execute package task.

You can create a package dynamically, you will need to use the API to do so and this is not an easy task.  There are some threads on it here in the forums as well as some postings out on the web that try to show how to do so… Just use your favorite search engine.

If you just want different parameters, and not to actually BUILD the package dynamically, for instance if you want to change a table name but the structure is the same, you could use parent package configurations to pass information to the package you are calling.  Alternatively, you could populate your configurations table or xml file in the parent and call the child after this processing is done.

Bookmark:Digg Del.icio.us Reddit