Integration Services in SQL Server 2005 Editions

Not all the editions of SQL Server 2005 include Integration Services. The following list shows how Integration Services is distributed across various editions of SQL Server 2005:

  • SQL Server 2005 Express Edition This entry-level free edition does not include Integration Services, though it does provide support for legacy DTS 2000 packages. You can run DTS 2000 packages in Express Edition, but you need to install SQL Server 2000 client tools or DTS redistributable files on the computer as Express Edition doesn’t include the DTS run-time environment. Also, be aware that the Express Edition includes an Import and Export utility, which is not the same as the SQL Server Import and Export Wizard and ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.