Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
polliux77
Starting Member
1 Post |
 Posted - 2009-07-16 : 04:57:54
|
| HI,I'm new on this forum,i have a lock problem with ssis package, in my package i have set isolation level properties to serializable, tha task call a stored procedure that have isolation level set to read uncommitted, who win?the stored or the package? sorry for my poor english.... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-16 : 14:23:19
|
| i think once ssis calls procedure, the control is with procedure, so i think within procedure the isolation level will be read commited |
 |
|
|
|
|
|
TRANSACTION IN SSIS PACKAGE