Post reply

Controlling Number of Asynchronous Operation

  • December 16, 2009 at 12:15 pm

    #139995

    Hi,

    I am developing an SSIS pkg that will be connecting to a mainframe using an ODBC connector. The cODBC connection is very limited in the number of connections that can be made thru it at one time. I need to throttle SSIS, so it does not exceed the number of connections (8). How do I do this? At present I have nothing created, so I'm looking for the best solution.

    Thanks,

    Bill W

  • December 16, 2009 at 3:34 pm

    #1093337

    wcwarner (12/16/2009)

    Hi,

    I am developing an SSIS pkg that will be connecting to a mainframe using an ODBC connector. The cODBC connection is very limited in the number of connections that can be made thru it at one time. I need to throttle SSIS, so it does not exceed the number of connections (8). How do I do this? At present I have nothing created, so I'm looking for the best solution.

    Thanks,

    Bill W

    Right-click on your connection manager and select Properties. Scroll down and find RetainSameConnection property. Set to TRUE. In this way only one connection will be used in your package.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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