Welcome to VSTSC's Community Server | | Help

April 2007 - Posts

Sunday, April 08, 2007 2:05 PM

SSIS Design Pattern - Custom Error Handling

I was working on error handling with SSIS recently and came up with what I believe is a snappy way to address it. The solution presented below is partial. For one, I would encourage you to use a database table to house errors; for another, I would encourage
Posted by andy | 1 Comments
Filed under: ,
Wednesday, April 04, 2007 12:48 AM

SSIS Design Pattern - EncryptSensitiveWithPassword

SSIS Design Pattern - EncryptSensitiveWithPassword Deploying SQL Server Integration Services packages is one of the steeper paths on the slopes of the SSIS learning curve. Like almost everything else in life, it makes perfect sense once you understand
Posted by andy | 0 Comments
Filed under: ,
Monday, April 02, 2007 11:45 PM

SSIS Design Pattern - Dynamic SQL

Introduction I sometimes miss the ActiveX task in DTS. It was cool because "if you could see it, you could change it." I used the ActiveX Task to generate dynamic SQL. When To Use Dynamic SQL In SSIS There are lots of uses for dynamic SQL in SSIS. If
Posted by andy | 1 Comments
Filed under: ,