As part of today's MacWorld festivities, I was reminded of something. Office:Mac 2008 doesn't support VBA anymore, and VBA support for the next version of Office for Windows is supposed to be limited to the ability to upgrade scripts to whatever new thing Microsoft has to replace VBA.
This is in addition to the issue I ran into a few weeks ago, where I was upgrading a system from SQL Server 2005 Standard to SQL Server 2005 Standard x64. DTS doesn't work on the x64 edition. Well, it's not supported. I got it to work, mostly, but it's not supposed to work, and I'm dreading the next service pack that may break it.
Many years ago, I helped write a very complicated system that collected data from many sources, transposed it and loaded it into SQL Server tables for use by OLAP. The accepted and probably recommended approach would have been to use DTS. Instead of using DTS, the files were collected with xp_cmdshell, parsed with a Perl script, loaded with BCP (this was before the Bulk Insert command happened) and the data was refined with Transact-SQL. Why did we use this approach? Because it was manageable and looked like it'd last the longest time.
I pity everyone who's developing using SSIS. I hope you enjoy re-doing all that work. Make sure you keep all your specs, in hard copy, because who knows what Microsoft Word's going to be able to read by then.