12 December 2007

Location Independent SSIS Packages

Jacob Sebastian of SQLServerCentral.com has a nice post today about creating location independent SSIS packages for SQL Server 2005. If you have more than about 3 SSIS packages take a look at this. You might want to move servers some day.

On a related note, Brian Knight will be at the December 18th oPASS meeting in Orlando speaking on the "12 days of SSIS". The event is at the RDV Sportsplex in Maitland and the fam has given me permission to stay out late that night so I'll be there.

There's something deliciously ironic about a bunch of geeks meeting at a world class sporting complex. Heaven knows I can't talk T-SQL and ice skate at the same time!