SQL Server Performance

sql 2005 with ssis 2008

Discussion in 'SQL Server 2008 Integration Services' started by acki4711, Feb 19, 2009.

  1. acki4711 Member

    Hi all,
    I just installed sql 2005 ent x64 sp3 and ssis 2008.
    When I try to connect to ssis from management studio I get:
    Connect to SSIS Service on machine "xxx" failed:
    The specified service does not exist as an installed service.
    The service is installed and running, might be the name of the service be a problem?
    "SQL Server Integration Services 10.0"
    Any help is highly appreciated.
    TIA
    acki
  2. ndinakar Member

    You need to use the BIDS that comes with SQL 2008 to connect to SSIS 2008.
  3. Saurabh Srivastava New Member

    Even though that doesn't make sense but that's "BY DESIGN" SSMS 2005 to SSIS 2005 and SSMS 2008 to SSIS 2008. Lot of People have raised their concern via Microsoft connect and logged it as a BUG but there are no +ve results yet. If I can connect to an instance of 2005 database engine instance from SSMS 2008 WHY NOT SSIS 2005. SSMS is just a tool for managing enviornment in efficient and effective manner, but this limits manageability.

Share This Page