Sunday, November 12, 2006

SSIS Presentation Online

I had fun at my latest presentation about using SQL Server Integration Services (SSIS) to about 100 people at Microsoft Canada. We covered the basics including sources and destinations, some transforms and of course the overall architecture of SSIS.

This is a brand new product that happens to ship with a great database engine called SQL Server. I make this comment because it’s important to determine at design time where actions are taking place. Sometimes, it’s better to perform operations within SSIS and other times you should take advantage of the database engine to perform an operation. You can handle both from within SSIS.

Microsoft has recorded the session and posted it online here: