Consider Biml API with BIDS Helper and/or EzAPI

Nov 28, 2011 at 3: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 <>, 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:


Nov 28, 2011 at 5: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.