locked
how to find out that SSIS Installed in SQLServer Using C#? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    i'm writing a windows form application using C# . i use 

      ssisServer = new IntegrationServices(ssisConnection);

    To run and working with SSIS Packages But Before running the Package i wanted To Make sure the user run the application in the correct system and sql server has the SSIS on It's Sql Server.so how can i find whether ssis is installed on the server or not in C#?

    Sunday, August 9, 2020 7:34 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Shahram,

    Maybe it is not a direct answer on your question, but you can easily check if you have SSIS installed. 

    SQL Server Feature Discovery Report to the rescue.

    Please check the following link: Discover SQL Server Components Installed Using SQL Server Discovery Tool

    Here is how it looks like:


    Sunday, August 9, 2020 1:50 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Shahram_Soft,

    We can open SQL Server Configuration Manager in Start page. And then we can check

    if the Integration Services is installed by clicking SQL Server Services.

    SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager<version>.msc file (such as SQLServerManager13.msc for SQL Server 2016 (13.x)) to open Configuration Manager. You will need the corresponding SQL Server Configuration Manager version to manage that particular version of SQL Server.

    Please refer to the following link and pictures:

    SQL Server Configuration Manager

    Best Regards,

    Mona

    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.



    Monday, August 10, 2020 8:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    In C#? SSIS is a service named "MsDtsServer…" and you can list services with ServiceController.GetServices Method, in PowerShell with

    Get-Service -Name "MsDtsServer*"

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    Monday, August 10, 2020 9:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Shahram_Soft,

    May I know if you have anything to update?

    Best Regards,

    Mona

    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.

    Friday, August 14, 2020 8:18 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Olaf Helpers Answer is working for me, i marked as an answer here.
    Monday, August 24, 2020 8:22 AM