Yay!!! I'll be speaking about Biml at SQL Saturday in Chattanooga in June! I'm very excited. In typical fashion, I will probably cram too much into the hour, but I'll try not to. Here's the abstract for my session. Using Biml to Automate the Generation of SSIS Packages So, you need to move data from … Continue reading SQL Saturday!!!
Now that we can generate simple empty packages, the next step is to add connection managers to the project and package. After that, we will add a DataFlow. This article will focus on the Connections though, and we will start with a pair of standard OleDb Connections. Recall the metadata tables from the last article: … Continue reading Biml Tutorial Part 3 – Adding Connection Managers to our Package Generator