EzAPI - Package Generation API (SQL 2012)

Rating:        Based on 7 ratings
Reviewed:  6 reviews
Downloads: 0
Change Set: 86517
Released: Feb 15, 2012
Updated: Feb 15, 2012 by mmasson
Dev status: Stable Help Icon

Available Downloads

There are no downloads associated with this release.

Release Notes

EzAPI - Package generation API

This sample provides some functionality to easily create SSIS packages programmatically and dynamically alter their objects (tasks, components, changing metadata, connection strings, etc). This framework supports:
  • Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
  • BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)
For more information, see the post on the SSIS team blog.

Written by Evgeny Koblov

Reviews for this release

     
sorry, there is no link to download the API
by rainer63 on Mar 26 at 12:35 PM
     
It sounds good. where is download for this version?
by greatlake5 on Oct 3, 2013 at 3:56 PM
     
Where is the link to download for EzAPI SQL 2012 version?
by stangud on Aug 10, 2013 at 5:35 AM
     
There is no download. Can't use other 2008 verison with SQL Server 2012
by Bill_connelly on May 27 at 6:41 PM
     
Very good. I had problems getting demos to work. They reference AddressPerson, some table that does not exist in AdventureWorks2008. I added some logic to spit out errors. The demo package returns success even it fails. p = new EzOleDbToFilePackage("DBA-ETL", "AdventureWorks2008", "Address", "c:\\result.txt"); ; p.DataFlow.Disable = false; p.Execute(); foreach (DtsError err in p.Errors) { Console.Write(string.Format("Error: {0}\n", err.Description)); }
by alendar on Feb 18 at 10:41 PM
     
EzAPI is a fantastic tool, that makes programmatically generating SSIS packages so much easier. I definitely prefer EzAPI over BIML, since with EzAPI you have access to SSIS component metadata, that may be used, for example, to create SQL tables on the fly, perform conditional operations based on column datatypes, etc. Keep up the good work!
by otykier on Sep 6, 2013 at 8:31 AM