THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

Speaking - Automate Your ETL Infrastructure with SSIS and PowerShell

Today at 4:45PM EDT I'm presenting a new session using PowerShell to auto-generate SSIS packages via the BIML language.  The really cool thing is that this session will be live broadcast on PASS TV! You can view the session by clicking on this link.

 If you have questions for me during the session, you can send them to me via Twitter using this hashtag:


 Brian Davis, my good friend from the Ohio North SQL Server Users Group, will be monitoring that hashtag and feeding me the questions that I can answer during the session.

I look forward to hearing from you on this great topic.


Update: The session (to me) went really well, and I appreciate everyone who attended. I've uploaded the slides and demo scripts to this post.  AW.


Published Wednesday, October 16, 2013 3:59 PM by AllenMWhite




Nathan said:

Have you successfully created BIML scripts that obtain the Schema of a Sybase DB?

GetDatabaseSchema method doesn't appear to work.

var sourceConnection = RootNode.AdoNetConnections["Source"];

var importResult = sourceConnection.GetDatabaseSchema();


<Biml xmlns="">


   <# foreach (var table in importResult.TableNodes) { #>

   <Table Name="Staging_<#=table.Schema.Name#>_<#=table.Name#>" SchemaName="DataPatternsStaging.stg">


September 7, 2016 12:56 AM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement