SSIS EXCEL CONNECTION ERRORS
EXCEL FILES CONNECTION ERROR.
Upvotes: 1<=-=Mar 14 2006 12:44PM=-=>
Thank you for using SQL server 2005 and SSIS
Apologies but I am not exaclty clear of the problem. Do the connection errors occur when you create more than 1 connection manager for the Excel file, in the same package?
Or do you have a single connection Mgr that you are using in a loop of some sort.
Can you please include the erorr text you see?
I can not repro the errors by trying out scenarios which have multiple Excel connection in a single pkg or a single Excel connection in a loop. Please reactivate if you can still repro and in that case please send more detailed steps to us.