wnarretto (10/8/2012)
1. when the ssis package has completed, does it cut off the connection to the spocs that were called for the other iterations?
Unless you're preserving your connection in the data source, those connections are severed on each object as it completes.
The problem you're running into, as you've seen, is your external call to a separate application. That app call returns as 'successful' immediately. I believe there's a switch where you can have BCP send back success/fail, but really... why are you calling BCP at all? You're IN SSIS already, why not just use a dataflow?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA