Avatar of BKennedy2008
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
DcpKing

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DcpKing

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
or
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
BKennedy2008

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

ASKER
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
DcpKing

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
Your help has saved me hundreds of hours of internet surfing.
fblack61