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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.