Koen: thanks for answering Vijay's question!
You mentioned an article in the Stairway Series called "Building an Incremental Load Package – Level 3" maybe I'm being thick but I couldn't find that article. There was one called "Adding Rows in Incremental Loads - Level 3" but that had no mention of BIML.
Could you provide the link to the article please?
"Building an Incremental Load Package - Level 3" is the title of the third installment in this series - the Stairway to Biml. As I type, Level 2 of this series (entitled Biml Basics - Level 2) has been written, edited, and is being scheduled by our most capable SQLServerCentral editor-in-chief, Steve Jones. Level 3 (Building an Incremental Load Package - Level 3) and Level 4 (Using Biml as an SSIS Design Patterns Engine – Level 4) are being revised by the authors, Paul Waters and myself. We have the demo built for Level 5 through Level 8 or so, and we are outlining the articles.
I promise we will get the articles published as soon as we can. Biml is exciting new technology - game-changing technology, in my opinion.
Bruce and Roshan Joe, I believe Biml will deliver. I look forward to your feedback as the series progresses.
Andy LeonardData Philosopher, Enterprise Data & Analytics