SQL Server Performance

Using DTS in SQL Srvr Express 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by adyseven, Jan 28, 2007.

  1. adyseven New Member

    Dear All,

    Just say, i'm using the free SQL Server Express edition 2005 to connect to database in a server. In server, we're using SQL Server 2000 Entprise Edition.

    My question is how to use the DTS in the server via SQL Srv Express 2005?

    Is there any way to connect to the DTS from Express 2005?

    Need ur response guys..thx in advance

    -ady-
  2. dineshasanka Moderator

    Support for SQL Server 2000 DTS Packages in SQL Server 2005 Express Edition

    SQL Server 2005 Express Edition does not include Integration Services or support for SQL Server 2000 DTS packages.

    To run existing DTS packages on a SQL Server 2005 Express Edition server, you must leave the SQL Server 2000 client tools or the DTS redistributable files on the server, or reinstall them. SQL Server 2005 Express Edition does not include the DTS runtime.

    To edit existing DTS packages on a SQL Server 2005 Express Edition server, you must use SQL Server 2000, or edit the packages remotely from a server running SQL Server 2005 Workgroup, Standard, Enterprise, or Developer Edition. SQL Server 2005 Express Edition does not include SQL Server Management Studio or BI Development Studio.

    To migrate existing DTS packages to SQL Server 2005 Integration Services, you must use SQL Server 2005 Standard, Enterprise, or Developer Edition. Other SQL Server 2005 editions do not include the Integration Services Package Migration Wizard.

    The Import and Export Utility that is included with SQL Server 2005 Express Edition is not the SQL Server Import and Export Wizard and does not use Integration Services.


    http://msdn2.microsoft.com/en-us/library/ms143706.aspx

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. satya Moderator

    I believe you have got the explanation from Dinesh's response above, in addition to that 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 Download Center athttp://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc.



    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  4. adyseven New Member

    Hi Satya,

    Thx for the explanation, it's enough 4 me, because i'll intend to using the existing DTS created in SQL Server 2000 instead creating a new one within the Express 2005. The SQL Server Express is used only for quering and executing the existing DTS.

    Anyway, the http link is unavailable, where else can i find this DTS runtime installer?


    quote:Originally posted by satya

    I believe you have got the explanation from Dinesh's response above, in addition to that 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 Download Center athttp://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc.



    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. satya Moderator

  6. adyseven New Member

    Hi Satya,

    From the link i've downloaded and installed the DTS designer component for SQL Server. But after that, i don't know how to use it because in the SMSSE there is still no node which named Data Transformation Services. Please advice...




    quote:Originally posted by satya

    Might tyr thishttp://www.microsoft.com/downloads/...60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en link.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. MohammedU New Member

    Expand the MANAGERMENT folder and then expand the LEGACY folder....then you see DTS folder....


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  8. satya Moderator

    Ady, I hope your issue is resolved and if not let us know.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  9. adyseven New Member

    Hi Satya,

    I've tried MohammedU suggestion, but still there is no folder named LEGACY under the folder MANAGEMENT.

    What else I supposed to do? Please help...

    Is there any component should be installed besides the DTS Designer?


    quote:Originally posted by satya

    Ady, I hope your issue is resolved and if not let us know.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  10. MohammedU New Member

    Support for SQL Server 2000 DTS Packages in SQL Server 2005 Express Edition

    SQL Server 2005 Express Edition does not include Integration Services or support for SQL Server 2000 DTS packages.

    To run existing DTS packages on a SQL Server 2005 Express Edition server, you must leave the SQL Server 2000 client tools or the DTS redistributable files on the server, or reinstall them. SQL Server 2005 Express Edition does not include the DTS runtime.

    To edit existing DTS packages on a SQL Server 2005 Express Edition server, you must use SQL Server 2000, or edit the packages remotely from a server running SQL Server 2005 Workgroup, Standard, Enterprise, or Developer Edition. SQL Server 2005 Express Edition does not include SQL Server Management Studio or BI Development Studio.

    To migrate existing DTS packages to SQL Server 2005 Integration Services, you must use SQL Server 2005 Standard, Enterprise, or Developer Edition. Other SQL Server 2005 editions do not include the Integration Services Package Migration Wizard.

    The Import and Export Utility that is included with SQL Server 2005 Express Edition is not the SQL Server Import and Export Wizard and does not use Integration Services.

    http://msdn2.microsoft.com/en-us/library/ms143706.aspx


    MohammedU.
    Moderator
    SQL-Server-Performance.com
  11. satya Moderator

    Confirm what is the service pack level on SQL 2005 instance you're running, though this is not related. I believe there were few issues with RTM version of SQL 2k5 and having DTS packages etc. As you have seen Dinesh's reply above that covers most of it about managing dTS packages in SSMS.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page