SSIS For Each Loop Container/File System task

Question

I have a File System task that will move a folder if a process job fails. The process job bulk inserts from a set of files. If one file fails the subsequent job to move the folder fails. I'm presuming that the process job is locking a file in the folder as I am getting and Access to path denied. Any ideas would be great.

What is a "process job"? You reference a subsequent job - is that a sql agent job or still part of SSIS? Perhaps a screen shot of your Control Flow and any other external processes might make your question a bit clearer — billinkc
– billinkc, Commented Apr 5, 2016 at 13:52

Johnny Fitz · Accepted Answer · 2016-04-05 14:01:55Z

0

Instead of moving the folder contents as part of a single task I split the task into a copy and then deleted the directory contents. The problem has not reoccurred.

answered Apr 5, 2016 at 14:01

Johnny Fitz

5422 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSIS For Each Loop Container/File System task

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related