Welcome to VSTSC's Community Server Sign in | Join | Help

Browse by Tags

All Tags » Design » SSIS » Patterns   (RSS)
Saturday, November 10, 2007 7:41 AM

SSIS Design Pattern - ETL Instrumentation, Part 2

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
Posted by andy | 5 Comments
Sunday, October 14, 2007 6:28 AM

SSIS Design Pattern - Read a DataSet From Variable In a Script Task

Introduction One of the things I appreciate about SSIS is the script elements. There is a lot of functionality built into the engine out of the box but I like the idea of having a Script Task on the Control Flow and a Script Component on the Data Flow
Posted by andy | 0 Comments
Filed under: , ,
Sunday, July 15, 2007 3:51 PM

SSIS Design Pattern - ETL Instrumentation, Part 1

Introduction SSIS is a fantastic ETL engine. When I build and ETL solution in SSIS, I like to collect runtime metrics. Why? I use the data initially to determine a baseline for performance and to determine, in some cases, if I'm loading within a defined
Posted by andy | 4 Comments