· Krehbiel Tech · Wednesday, May 31, 2006, 1:34 PM · 196 words
At work, I've been playing with SQL Server Integration Services (SSIS) for use in an upcoming project. ("Integration" is one of those fancy "enterprise" terms that means "getting information from different places and organizing it into something useful.") There's some value in SSIS, but overall I'm not terribly impressed. In fact, it's a bit of a pain. I can see using it for simple tasks like pulling data from one place and putting it into another place, but for anything more complex than that I'd prefer to use something else (like C#). It's not really a programming tool, in my mind. I'm currently on day 2 of trying to merge data from several different Access databases together into one SQL Server database, a process that might have taken a few hours to build in C#, but using this graphical "flowchart" interface to build code logic is a little nauseating. I suppose it looks pretty on the screen, and a programming n00b might be able to look at it and understand it, but it sure is slow to put together what should be fairly straightforward logic. Hurray for the newest buzzword technology from Microsoft!