Friday, March 23, 2012

HOW TO USE SSIS (DTS) IN SQL EXPRESS

I ′m trying to use ssis in Sql Express in order to replace my old DTS that I used in MSDE but I found that SSIS doesn′t work in Express, question is

How could I use new DTS technology in Express ?

Thanks in advance.

SSIS does not come with Express or Workgroup editions of SQL Server 2005. See Integration Services with Basic Transforms here http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Derek

|||

The SQL Server 2005 Backwards Compatability Components include the DTS2000 Runtime that will allow you to use your old 2000 DTS packages in SQL Express. You can download it from the SQL Server 2005 Feature Pack page.

Regards,

Mike Wachal

No comments:

Post a Comment