Avatar of BKennedy2008
 asked on

SSIS with SharePoint List configuration

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
Web Languages and StandardsMicrosoft SQL Server 2008Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

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

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.


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 ...


Your help has saved me hundreds of hours of internet surfing.