Are you using Biml yet? Why not?!
Business Intelligence Markup Language (Biml) speeds and simplifies SSIS development and improves code quality. There’s a good reason that sounds like a win/win – it is a win/win! Best of all, BidsHelper supports Biml and it is free.
BimlScript.com contains a collection of sample, functional Biml snippets and code that demonstrate all kinds of cool functionality. And again, it is also free.
I wrote about Biml in SSIS Design Patterns and deliver a presentation titled Using Biml as a Design Patterns Engine. I like it. A lot. I have started publishing Biml code at BimlScript.com – beginning with an example from the book: Incremental Load Design Pattern. Check it out and let me know what you think… and happy Biml’ing!
:{>
Andy,
I want to do incremental load with BIML script using CDC. Is there any link or document which can help me build my solution using CDC. Thanks in advance.
Thanks and Regards,
Samit Shah
Hi Team,
I have some question in BIML, but I am unable to create any blog for the same. My issue is stated below.
I need to schedule BIML script to generate SSIS package. How can we do the same.
Thanks in advance,
Vipin
@Samit In case anyone is looking for an answer to your question in the comment here is a blog on using BIML with CDC.
http://blog.in2bi.eu/biml/change-data-capture-cdc-and-biml/
@Vipin If you are using Mist, you can purchase a compiler license from Varigence which would allow you to schedule MSBuild tasks to generate BI Assets such as SSIS Packages. I would question your motive if the SSIS package changes on a schedule. This sounds to me as though you are looking for a variable mapping to a configuration vs needing to regenerate the package.
Michael
Michael,
Thank you for that post and for adding the comment here. Awesome work, sir.
:{>