I was in training all last week learning SQL Server Integration Services (SSIS). For anyone who cares, that is a ETL (Extract/Transform/Load) tool used to move data around in databases/flat files/excel and in building data warehouses. I think that it’ll be useful for some projects I’ll be working on in the near future. SSIS is still a bit quirky in my opinion though. The syntax of the expressions doesn’t seem to match SQL or VB. So it makes it somewhat confusing when you are constantly going in an out of sql and vb and then back to SSIS style expressions. Another thing that annoyed me was the lack of support for C# for script tasks. It’s been awhile since I’ve developed using VB so I was a bit rusty trying to do some of the labs that required scripting.
