开发者

File In Use error in SSIS

开发者 https://www.devze.com 2023-02-05 19:03 出处:网络
I currently have an SSIS package which runs a foreach loop around a folder and stores rows from in a number of Excel worksheets into a database. This works just fine.

I currently have an SSIS package which runs a foreach loop around a folder and stores rows from in a number of Excel worksheets into a database. This works just fine.

Outside the loop, I then have a foreach loop which follows to move the processed files into another folder. When it reaches this point, I get an error of

The process cannot access the file because it is being used by another process.

I've tried putting in a 10 second del开发者_运维百科ay step, but that still isn't helping. Is there any way around this?


Sometimes the lock hasn't been released. You could try something like this: http://microsoft-ssis.blogspot.com/2012/01/custom-ssis-component-file-in-use-task.html


Doesn't seem like you should have to do this, but you can adjust the maximum concurrent executables and threads. May help, but will also reduce performance.

http://blogs.msdn.com/b/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号