Dynamic Package Generation Sample

Rating:        Based on 5 ratings
Reviewed:  3 reviews
Downloads: 9457
Released: Sep 24, 2008
Updated: May 29, 2012 by yunhu
Dev status: Alpha Help Icon

Recommended Download

Application PkgGenReadMe_SQL2012.rtf
application, 255K, uploaded May 29, 2012 - 1561 downloads

Other Available Downloads

Application PkgGen.exe
application, 34K, uploaded May 29, 2012 - 3174 downloads
Documentation PkgGenReadme.rtf
documentation, 216K, uploaded May 29, 2012 - 4121 downloads
Documentation PkgGen_SQL2012.exe
documentation, 34K, uploaded May 29, 2012 - 601 downloads

Release Notes

Package Generation Sample

This sample demonstrates package generation and execution using the Integration Services object model. The sample can be used to transfer data between a pair of source and destination components at the command line. The sample supports three types of source and destination components: SQL Server, Excel and flat file. Use this sample to learn more about how to:
  • Create packages using the SSIS API
  • Validate packages using the SSIS API
  • Execute packages using the SSIS API
  • Add type conversions using the SSIS API
Written by Jia Li

Reviews for this release

i haven't seeen
by zengxinwen on Jul 4, 2011 at 7:05 AM
I have don this package jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj
by haikapish78 on Jul 9, 2010 at 5:17 PM
This is a great sample. I have used this in a extraction template where I use this component to dynamically generate the package from table driven configurations. This is quite useful as now with a single SSIS package I am handling 100 plus extractions. I made couple of small changes to the source code to support SQL command data access mode in OLEDB source and fast load for OLEDB destination.
by evraghuram on Jul 2, 2010 at 6:55 PM