将DTS迁移到SQL Server 2008时注意

在2005年育空方式的Beta程序期间，微软让我们知道新的DTS（很快重命名为SSIS）将无法翻译100％的DTS 2000脚本代码，我们在前5次工作年（或更长时间）。嗯，仍有许多客户在迁移上工作。也许它更容易直接到2008年？我正在努力的最新项目是这样做......将DTS 2000包转换为SSIS 2008.大问题区域是ActiveX脚本任务。SSIS迁移向导与这些任务没有太多。实际上，它只将代码复制到注定使用SSIS对象模型失败。该建议是完全重写这些任务，以便您可以使用VB.NET，C＃.NET，IntelliSense，Debug和所有良好的Visual Studio的内容。这就是我们应该做的事情。但那需要时间。 Maybe a long time. Of course, the Microsoft compromise was to allow DTS packages to be run natively in SQL Server 2005 and now 2008. We can still use DTSRUN as long as we install the DTS Runtime. This is part of the Backward Compatibility Feature Pack: http://msdn.microsoft.com/en-us/library/ms143755.aspx Also, you can run a DTS 2000 package, as is, from an SSIS Package using the aptly named Execute DTS 2000 package task. This effectively submits the DTSRUN statement for you from within an SSIS package. If you imported the DTS package to SQL Server 2005 or 2008, you can tell your boss that your packages are now running in SSIS, even though you have not had to make any code changes. If you have migrated your SQL 2000 databases, you can turn off that SQL 2000 box and retire it. Everything is now off the legacy server. But what if you want to make a small change to your DTS package without having to migrate completely to SSIS Scripting? Well, you can install the DTS Design Components in SQL 2005 or 2008. Then you can use SSMS Legacy folder and launch the DTS Designer from there, or from within BIDS. This again is a download from the same technote: http://msdn.microsoft.com/en-us/library/ms143755.aspx However, there is a bug in the install (which actually is the same install for both SQL 2005 and 2008). You need to play with the PATH environment variable to make sure that the "80\Tools\Binn" folder is before the "100\Tools\Binn" folder. The install MSI puts it at the end, so you get the same error again. The technote (now officially in Books Online) tries another tack: copying DDLs and RLLs from various folders (take a look!). On top of that, the instructions are not strictly accurate so make sure you scroll down to the bottom of the online version to see the bug report for the bug correction! I am sorry, since it is now documented, it is no longer a bug; it works as designed and is now a feature. It's lucky that, as DBA's, we have to have a sense of humor, isn't it? That is, until 2011 when DTS is deprecated... cheers Brian