December 2, 2008 at 1:06 pm
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,
December 3, 2008 at 2:21 pm
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.
December 3, 2008 at 8:05 pm
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, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
December 4, 2008 at 7:48 am
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)
May 3, 2016 at 7:37 am
I am working on a project similar to that. Can you give updates on your progress please.
May 3, 2016 at 7:47 am
Have you checked BIML? it might help you create dynamic SSIS packages.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply