Consider Biml API with BIDS Helper and/or EzAPI

Nov 28, 2011 at 4:18 AM

This is great work.  I currently support a decent sized mortgage analytics group in which I need the "swiss army knife" SSIS tools like this to get things done. Currently, I leverage EzAPI <http://sqlsrvintegrationsrv.codeplex.com/releases/view/21238>, not sure if you have read about it, but it's definitely along the lines of your thinking - just thought i'd pass it along.

Also, wanted to mention the Biml API included with the BIDS Helper on CodePlex:

<http://bidshelper.codeplex.com/wikipage?title=Biml%20Package%20Generator&referringTitle=Documentation>

Coordinator
Nov 28, 2011 at 6:14 PM

Yes, I mention the EzAPI at the beginning of the description of my project.  I discovered it too late.  My project is probably useful in these cases:

  • For whatever reason, the EzAPI doesn't fit your needs and you need complete API examples.
  • If you need to use it as is: a way of importing various kinds of data directly into temporary all-varchar-column databases.