none
Is that possible to execute SSIS in ASP.NET at 64bit environment (SQL 2008R2, Windows Server 2008 R2) RRS feed

  • Question

  • I got issue that try to execute SSIS in APS.NET and did not found much answer on it. Does anyone solve this problem already? thank you

    Thursday, December 30, 2010 6:18 PM

Answers

  • Hi tonychi2005,

    By default, we can use the DTS object to execute a SQL Server Integration Services(SSIS) package directly.

    However, in this case, you said you tried to run a SSIS job. This is a little confused. Do you mean you have configured a SSIS job in SQL Server, and now, you try to execute the job?
    If so, please connect to the SQL Server from ASP.NET, and then use the stored procedure sp_start_job to start the specify job.

    Anyway, the following article details how to execute a SSIS package from ASP.NET:
    http://www.codeproject.com/KB/aspnet/SSIS_DOTNET.aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Friday, December 31, 2010 9:02 AM
    Moderator

All replies

  • Can you share more details on what you've tried?  SSIS must be installed (and licensed!) to be able to run via the API.
    Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer
    Thursday, December 30, 2010 6:42 PM
    Moderator
  • I tried to run a SSIS job through Web application, for what I have researched it looks like needs to use DTS, which by default SQL Server 2008 R2 is not include this package. I have installed all the services in SQL Server 2008 R2 that included SSRS, SSAS, SQL Agent and etc. What I try to do is write a program through VS 2010, but I can not get it working.

    Thursday, December 30, 2010 6:52 PM
  • Hi tonychi2005,

    By default, we can use the DTS object to execute a SQL Server Integration Services(SSIS) package directly.

    However, in this case, you said you tried to run a SSIS job. This is a little confused. Do you mean you have configured a SSIS job in SQL Server, and now, you try to execute the job?
    If so, please connect to the SQL Server from ASP.NET, and then use the stored procedure sp_start_job to start the specify job.

    Anyway, the following article details how to execute a SSIS package from ASP.NET:
    http://www.codeproject.com/KB/aspnet/SSIS_DOTNET.aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Friday, December 31, 2010 9:02 AM
    Moderator