This project is read-only.
A tool (developed using Biml) which automatically generates SSIS package for pulling data from various SQL Server sources and saves 80% of SSIS development effort.
This works with SQL Server 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT).

ToolArchitecture.PNG

Problem with manual package creation for data pull

  • Need to manually drag and configure SSIS components individually
  • Need to write CREATE-TABLE script
  • Need to write SELECT script in OLE-DB source
  • Naming conventions must be followed properly

If these are the things where you spend most of the development time, then let this tool handle development of SSIS package while you continue focusing on key transformations. Here is the snapshot of the package created using this tool in no time:

SamplePackage.PNG

How to use

All of the features of this tool are documented under the Documentation tab.


Last edited Jan 14, 2014 at 7:04 PM by braveson, version 17