SQL Server Performance

dts MsSQL2000 can run on mssql 2005?

Discussion in 'SQL Server 2005 Integration Services' started by tboonleong, Mar 2, 2007.

  1. tboonleong Member

  2. MohammedU New Member

    The Data Transformation Services (DTS) runtime, included with MSDE, is not included with SQL Server 2005 Express. The DTS runtime allows SQL Server 2005 Express to run existing DTS packages. Though not built-in to SQL Server 2005 Express, the DTS runtime components can be downloaded and installed along side of SQL Server 2005 Express. You will find the DTS runtime installer on the Microsoft Download Center at
    http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc.


    http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx



    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. tboonleong Member

    In the ms sql 2005 express edition,can we edit the related DTS or design the related DTS as well?

    The MS SQL 2005 EXPRESS edition can run the dts at run time then how can it to be done?and any interface or function to run it.

    Hope to get the details. thanks again.

Share This Page