We have a client where we recently swung their SBS2003 Premium installation to a new server. (Old server was a 1U rack mount, they were running out of drive space and didn’t have room for more than two drives, and they wanted a TS . . . so new server gets SBS, old server becomes TS). ANYWAY, this client is running SAP Business One as their accounting / CRM suite. The president is pretty techy and does a decent amount of development-type projects. In fact, he has an MSDN Universal subscription and purchased the SDK for SAP Business One so he could build some various automation projects. Well, it turns out that he was using about a dozen different DTS packages on his SQL server that he was using for his automation processes, and naturally wanted this moved over to his new SBS.
Well, I’ve dabbled with SQL for a while – I’d argue that I know more than enough to just get myself into trouble, but I wouldn’t consider myself a SQL admin by any stretch of the imagination :^) Needless to say, I had never really messed with Data Transformation Services, let alone be in a position where I needed to move packages around. Google gave a few options – but SBS MVP Merv Porter (our search engine king) offered one find in particular that proved super-simple: DTSBackup2000 It’s a free download, super-simple and works perfectly . . .
You know, the best thing about my job is learning something new every day . . . :^)