dndaughtery (7/7/2014)
I have another connection mgr connecting to this excel file in a file task to rename it just before the connection manager in the dataflow is used. Could it be possible that the file hasn't had time to be released from the File task before the connection mgr in the dataflow is trying to access the file?
Possibly, but I would guess more that it's sent the command but the network hasn't refreshed the settings on the file yet.
What happens if you direct execute the dataflow, without the renaming, do you still get the same error?
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