Creating Dynamic SSIS Packages

Question

Creating Dynamic SSIS Packages

stevoid1970

Old Hand

Points: 384
More actions
December 2, 2008 at 1:06 pm

#132534

I am in the process of designing a data delivery system. This system is meant to be used by a data analyst using drop downs to pick source servers, dbs and tables and destination servers, dbs, and tables. The database plan has been created. So basically we are thinking of using a job to poll a table. Once this job sees that a package needs to be created, it calls another package or job and then this package or job dynamically creates the package. The packages will not permanently be built but instantiated then killed and created every time it needs to be. The one thing that has to happen, is the package must be created, executed, then the process must move on to the next delivery, create the next package and so on. So, the big question, how does someone go about doing this? Thanks,

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Dave23 Hall of Fame Points: 3903 More actions · Answer 1

Are the input and output field collections similar enough overall to allow a previously-created template package or limited set of packages to be modified via Package Configuration settings that are specified by the analyst?

For execution, you could use a static parent package to execute the ephemeral child packages.

Tim Mitchell SSCoach Points: 15685 More actions · Answer 2

Your problem definition says that you need to dynamically create packages, but you didn't specify why you need to do this. Can you provide more detail about the problem you are trying to solve?

Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices

dave-dj SSChampion Points: 11297 More actions · Answer 3

found this and very very quickly skimmed over it, but it might be worth a look for you.

Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component

http://www.sqlservercentral.com/articles/SSIS/63877/

Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages

http://www.sqlservercentral.com/articles/Integration+Services/64572/

_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

horwarh Valued Member Points: 65 More actions · Answer 4

I am working on a project similar to that. Can you give updates on your progress please.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 5

Have you checked BIML? it might help you create dynamic SSIS packages.

Stairway to Biml[/url]

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2