SQL Server Performance

DTS option

Discussion in 'SQL Server 2005 Integration Services' started by amara, Dec 8, 2006.

  1. amara Member

    Where do we find the DTS option in SQL Server 2005.
    And also,can we restore the packages written in SQL 2000 into SQL 2005

    Please advise me
  2. madhuottapalam New Member

    Hi,

    The DTS is replaced with Integration Services(SSIS) in SQL Server 2005. for backward compatibility you can go to Management Studio --> Management -->Legacy -->Data Transformation Service option . You can import SQL 2000 package using Import package option. But this will not be available in future versions of SQL Server. So it is better to convert DTS to SSIS package.

    Madhu

  3. satya Moderator

Share This Page