none
Multiple users trying to run Same SSIS package

    Question

  • I have a SSIS package which will be used by ASP.NET page to load data. Now, there are multiple users trying to upload the file at the same time. Each user has a different input file name and input file connection string. How can I achieve this ? Also, I have to run the SSIS package on a remote machine as web server does not have SSIS service on it. Please suggest.
    Thursday, July 25, 2013 4:50 AM

Answers

  • Two things,

    1. Each users are uploading their own file having same format.

    2. Refer the below code, For each user you can set different source file path using the ssis parameter. And moreover the ssisPackage object are created for each session users. i.e For every call to the web services method ssisPackage object will be created. Hence the package will execute in different instances for each users.

    ----------------------------------

    Microsoft.SqlServer.Dts.Runtime.Application integrationServices = new Application();
    Package ssisPackage = integrationServices.LoadFromSqlServer(packagePath, serverName, null, null, null);
    ssisPackage.Variables["ParameterName"].Value = "ParameterValue";
    DTSExecResult result = ssisPackage.Execute();


    Regards, RSingh



    Friday, July 26, 2013 8:25 AM

All replies