Post reply

Component required to execute SSIS package

  • June 9, 2011 at 4:40 am

    #241050

    hi all,

    What components are required to execute SSIS Package.

    I am executing it through Dot net. Does my application server require SQL Server engine too.

    [font="Arial Narrow"]Failure is not the worst thing. The worst Thing is not to try[/font]

  • June 9, 2011 at 5:01 am

    #1336169

    SSIS does not need SQL Server installed on the same machine, unless you require to access SQL server on that box.

    To invoke a SSIS package from C#/.NET:

    1) Reference assembly Microsoft.SQLServer.ManagedDTS.dll

    [font="Courier New"]Application app = new Application();

    Package pkg = new Package;

    try

    {

    pkg = app.LoadPackage("C:\myssispackage.dtsx", null);

    // set varaibles if required

    DTSExecResult res = pkg.Execute();

    }

    catch (Exception ex)

    {

    // handle exception

    }[/font]

  • June 9, 2011 at 9:00 am

    This was removed by the editor as SPAM

  • June 9, 2011 at 12:45 pm

    #1336641

    stewartc-708166 (6/9/2011)

    However, the SSIS DTEXEC components must be installed on the machine to be used (otherwise the reference assembly will not be available)

    Good point 😀

    SSIS must be installed even if you do not install any other components from SQL Server.

Viewing 4 posts - 1 through 3 (of 3 total)

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