Committed myself to SSIS. Spent the last week learning as I developed a beautiful package that executes flawlessly on my SQL 2008 Development box, ONLY to find out that it can't run on my Production Server because it's SQL2005! Help!
I'd LOVE to bump this server up from 05 to 08, but I'm just not sure that's an option for me at the moment.
Am I going to have to port the package to SQL2005? Any ideas out there? Can I install just SSIS 2008 on the SQL2005 server? The installer seems like it supports that.