SQL Server Performance

MSDE DTS in SQL 2005 Express

Discussion in 'SQL Server 2005 Integration Services' started by MES374, May 11, 2006.

  1. MES374 New Member

    Hi,

    I have a DTS package I use in MSDE to roll ODBC data source data into a MSDE SQL database. It appears DTS and it's replacement, SSIS in not part of the SLQ 2005 Express packge.

    Any ideas on how to provide the same capiblity of moving bulk ODBC connection data into a SQL 2005 Express database?

    My process is to truncate the tables and re-insert the new data.

    (I prefer off the shelf tools as opposed to custom programmed applications)

    Thanks...

    -Mark-
  2. satya Moderator

    SQL Server Integration Services, the replacement for Data Transformation Services (DTS), is installed side by side with DTS. You can run DTS packages using the DTS runtime components.

    I think DTS packages from SQL 2000 will continue to run if they are copied to SQL2005 server - but I have not tried this yet. DTS packages from SQL 2000 are under:-

    Management/Legacy

    They are created in Business Intelligence Development Studio (Search for Business Intelligence Development Studio in Books on-line).

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. MES374 New Member

    Hi Satya,

    Thanks for your feedback.

    I think the my problem is SQL 2005 Express edition does not install or support SSIS. In everything I have seen on Microsoft's site, Express edition only uses BCP for moving data into a SQL database.

    I have not seen anything to indicate that SSIS can be installed stand alone with the Express version of SQL 2005.

    If I'm interpeting MS website correctly, the Work Group edition and above do have support for SSIS and backwards compatibility for DTS.

    Thanks...

    -Mark-

Share This Page