I need to import csv data from a secured Sharepoint into a SQL table. Running the package in BIDS imports the data successfully... using the path
\\sharepoint.partners.extranet.microsoft.com@SSL\DavWWWRoot\sites\FileName.csv, (built using an expression). Using a proxy account (as myself) running in it as a job step in the SSIS package store, it gives the following error: Description: Connection
"TLDFlatFile" failed validation. Code: 0xC001401E The file name property is not valid. The file name is a device or contains invalid characters.
I am able to copy/paste the file from the sharepoint at the command line..but doing so in a job step using an OS command gives an "Access is denied" error.
Is it possible to import the csv file directly from the secure Sharepoint using SSIS, or to copy/paste it to a location on the destination server to be able to import with SSIS?
OS:WinSvr 2008 Enterprise
SQL: version 10.50.1600
Visual Studio 2008
View Complete Post