What is the SSIS package accessing the same table for? To read values out of the inserted row?
If it's to read values out of the row, then what you need to do is make those variables in the SSIS package, and pass them in using the /Set options in dtexec, and make it so it doesn't have to read the table.
Will that work for you?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon