SSIS Copy file from SharePoint library using File System Task permissions issue?

• metralgia

  Ten Centuries

  Points: 1005

  More actions

  June 19, 2015 at 11:11 am

  #301776

  Hi,

  Historically I've always written a VB script to copy a file from a sharepoint library. I don't like this method because I have to input a username & password in the script and maintain a config file.

  Yesterday I was playing around with using a file system task. The sharepoint file has a UNC path so why not? I created a simple test package with a single file system task that copies the sharepoint file (addressed via UNC) to another network location. Package runs fine locally.

  I try running on our utility server but am getting a "The file name [SHAREPOINT UNC PATH] specified in the connection was not valid" error. Package is running with a proxy on the server and the proxy account has the same permissions to the sharepoint site (so far as I can tell) as me.

  Any ideas?? I'd love to make this work.