http://www.sqlservercentral.com/blogs/koen-verbeeck/2013/11/13/create-etl-solutions-faster-with-metadata-driven-development-session-materials/

Printed 2014/08/27 09:41AM

Create ETL solutions faster with metadata driven development – Session Materials

By Koen Verbeeck, 2013/11/13

Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great audience, fantastic speakers and nice booths by the sponsors (especially the bar with Belgian beer was pretty awesome). It was great meeting up with the #sqlfamily again.

Anyway, I gave a session about using BIML to generate SSIS packages based on metadata. The session went pretty well: demos didn’t crash and the audience had some good questions (which I was luckily able to answer).

For those of you interested, you can download the slide deck of the session – which contains a lot of links to very useful resources – at slideshare. I used a small application I wrote to upload flat file metadata to a database. You can find the code here. I do not provide any support however and using it is at your own risk. A zip file with sample flat files, the .sql scripts and the BIML script used in the demos can be downloaded here.

If you attended the session, I hope you enjoyed it and that you consider using BIML in your next projects.

See you at the SQL Server Days next year!


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.