Post reply

SQL Server Integration Services

  • February 18, 2008 at 2:23 pm

    #179304

    I have installed SQL Server Integration Services on my WinXP client but there is no way I can see to launch it, it is not in my start menu, am I missing something. I installed it from the SQL Server CD and selected Integration Services as Workstation components, Books Online and Development Tools were already installed.

    Any incite would be appreciated

  • February 18, 2008 at 3:04 pm

    #779480

    It should be under All programs --> Visual Studios.

    -Edit:

    Sorry I'm still running on SQL 2000 at work. I was answering by memory.

  • February 18, 2008 at 3:25 pm

    #779487

    Thanks for the response, but there is no Visual Studio thats the problem there seems to be no shortcut or executable to run. I have Microsoft SQL Server 2005 but the app is not in there either

  • February 18, 2008 at 3:33 pm

    #779488

    fred (2/18/2008)

    Thanks for the response, but there is no Visual Studio thats the problem there seems to be no shortcut or executable to run. I have Microsoft SQL Server 2005 but the app is not in there either

    Hello Fred,

    If you have installed SQL Server 2005 then it should appear as

    Start --> Programs --> Microsoft SQL Server 2005 --> SQL Server Business Intelligence Development Studio

    and not in Visual Studio. It can be accessed through Visual Studio also as the GUI environment is the same.

    Hope this helps.

    Thanks


    Lucky

  • February 19, 2008 at 6:46 am

    #779685

    Lucky,

    Thanks for the reply, therein lays the problem, there is no SQL Server Business Intelligence Development Studio in the Microsoft SQL Server 2005 group. I have installed the workstation tools as well as Integration Services but not SQL server itself onto my workstation, should not SQL Server Business Intelligence Development Studio install as a workstation app?

    Thanks

    Fred

  • February 19, 2008 at 9:48 am

    #779798

    fred (2/18/2008)

    I have installed SQL Server Integration Services on my WinXP client but there is no way I can see to launch it, it is not in my start menu, am I missing something. I installed it from the SQL Server CD and selected Integration Services as Workstation components, Books Online and Development Tools were already installed.

    Any incite would be appreciated

    If you want to work on a SSIS package (new or existing), then you will need to launch Business Intelligence Development Studio and open the project or create a new one.

    If you want to connect to an existing SSIS instance, you will need to use SQL Server Management Studio, go to Object Explorer, connect to your instance.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply