SSIS with SharePoint List configuration

BKennedy2008
BKennedy2008 used Ask the Experts™
on
Hello Experts!
I am not, and this is what I need assistance in......

I have a SSIS Package looking at a mapped drive of SharePoint 2010 through DavWWW so it looks like a regular drive.
I am using the File Watcher task in a FOR Loop Container. Once a file is found, then it performs a Copy of the file to another folder. That's all I need it to do...

When I execute it, it copies over the same file over and over again and does not do anything with new files.....
I know I am totally missing something here, and not sure what it is.
Any help would be greatly appreciated...

Here is the configuration along with a for loop file variable, Placement.


config1config 2config 3
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
You missed one little task: move the file from the watched directory after you've copied it.

The Watcher task looks every time it's called, and, if you don't get rid of the file, it'll do what it's told again. and again. and again!!

Add another File System task to delete the file after you've copied it and you'll be fine. Alternatively, make yourself an Archive sub-folder under the one being watched and move it there after copying it .

hth

Mike

Author

Commented:
Ouch...I guess I see your point...Let me test the move theory....

Author

Commented:
Well, I see it. That shoots down my plan on getting copy's of files as they are uploaded to SharePoint becuase I cannot move the files, as it defeats using Workspace 2010 with Sharepoint.

I guess I will seek other means of getting a copy of this file, maybe through a Workflow setting??.. Anyways you answered my original question.

Thanks

Commented:
You need another bit of logic then - let the watcher see that there's a file, but, every time you copy one, copy the oldest in the folder and only watch for files newer than that ...

hth

Mike

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial