开发者

Does SSIS perform connections Lock?

开发者 https://www.devze.com 2022-12-30 02:50 出处:网络
I have read that SSIS performs variable lock in scripts. So when scriptA and script B use the same variable one of them will wait for the other to finish.

I have read that SSIS performs variable lock in scripts. So when scriptA and script B use the same variable one of them will wait for the other to finish.

Still I dont know id this is the same for Connection Strings.

For example I have two HTTP Connections being used in two webservices. if they 开发者_开发技巧are called constantly I am testing what happens.


Your assumption about SSIS variables is incorrect. SSIS doesn't perform "semaphore" type locking on variables. It won't "serialize" execution in order to allow two scripts that use the same variables to execute without interfering with each other. SSIS will fail the script that attempts to use a variable that is already in use by another script. If you think about it, it makes complete sense - having it operate any other way invites unpredictable race conditions.

There is no such thing as a "connection string" in SSIS. They are Connection Managers. An HTTP connection manager will manage a pool of HTTP connections. But I don't understand how that relates to "locking"?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号