I'm building a package that has a Data Flow which reads an Excel File using the Excel Source connection - during development I hit errors in steps after the excel read. This is causing the excel file to be locked up and the next run fails on excel connection problem. If I go to Excel I can't open the file either. I have to exit BIDS and then file gets released. Is there any setting / different approach that would prevent this from happening?
thx
I doubt there is a setting - its just unfortunate I guess.
This probably won't happen if you run the package from the command line - so try that!
-Jamie
No comments:
Post a Comment