VSTSC's Community Server

Introduction This post is part of a series of posts on ETL Instrumentation. In Part 1 we built a database to hold collected SSIS run time metrics and an SSIS package to deomnstrate how and why we would load metrics into the database. In Part 2 we will expand on our database and the SSIS package to annotate version metadata, manage error ...

Introduction   Loading data from a data source to SQL Server is a common task. It's used in Data Warehousing, but increasingly data is being staged in SQL Server for non-Business-Intelligence purposes.   Maintaining data integrity is key when loading data into any database. A common way of accomplishing this is to ...

I had this idea earlier to create a series of posts under the heading ''SSIS Cookbook.'' I've reconsidered the naming of the series - not the content. I'm going to call it SSIS Patterns. It will include common tasks I've run into with SSIS - and maybe a preview of upcoming technology. :{> Andy 

I've read several MSDN SSIS Forum posts recently on the topic on configuration and deployment management. I get these questions in most of my SSIS classes as well. One suggestion I've been investigating is using the DontSaveSensitive ProtectionLevel property and passing the connection string or password at execution time. I'm a test-it-and-see ...