Post reply

limit concurrent SSIS sessions

  • March 22, 2007 at 9:34 pm

    #116263

    I deployed a SSIS package to SQL server by which 3 tables are refreshed from an external data source.

    I ave an .Net application to call the SSIS package from a web page.

    How do I prevent the package from being called by 2nd user when it has been called by a user and the data refreshing is already in progress?

    Thanks

  • March 22, 2007 at 10:20 pm

    #696534

    try using some database intelligence with the user u r running the package with, so that only 1 connection for the user can exist in the SQL Server else denied access or says user currently logged in.

    Regards,

    Nitin'

Viewing 2 posts - 1 through 1 (of 1 total)

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