Blog Post

SQL Server Integration Services (SSIS) Blog
1 MIN READ

EzAPI - Update

SSIS-Team's avatar
SSIS-Team
Copper Contributor
Mar 25, 2019
First published on MSDN on Dec 12, 2010

I’ve just updated the http://sqlsrvintegrationsrv.codeplex.com/releases/view/21238 – an alternative SSIS package creation API. If you missed the http://blogs.msdn.com/b/mattm/archive/2008/12/30/ezapi-alternative-package-creation-api.aspx , I definitely recommend checking it out.

Updates include :

  • Support for additional containers, tasks and components
  • Bug fixes from the team
  • Additional patches submitted by Codeplex users

List of additional containers, tasks & components supported in the new version of EzAPI:

  • Sequence container
  • For each loop container
  • Transfer database task
  • Execute process task
  • File system task
  • Execute SQL task
  • Excel source adapter
  • Excel destination adapter
  • Union all transform
  • Merge & Merge join transform
  • Conditional split transform
  • SCD transform

Major bug fixes and patches are in the following areas:

  • Reinitialization of component metadata
  • Setting UsageType of columns
  • Support for FastLoad option in OLE DB Destination
  • Flat file connection manager properties & column metadata
  • Mapping in Data Convert transform

Remember, you can also download the http://sqlsrvintegrationsrv.codeplex.com/SourceControl/list/changesets (as well as all of our samples on the http://sqlsrvintegrationsrv.codeplex.com/ ).

Enjoy!

Updated Mar 25, 2019
Version 2.0
No CommentsBe the first to comment