December 29, 2010 at 9:29 am
We have clients sending us fixed-width text files that we need to upload into our reporting db. Our IT dept is already copying from the FTP and placing onto an internal Sharepoint site. My job is to get that data into our reporting db.
Is there a way to process the *contents* of each of those files on the Sharepoint list directly using components in SSIS, or do I need to write a script to do so? I found this article which talks about processing Sharepoint lists, but I want the contents of each file, not just the columns within that list, so those connectors, while cool, don't help me.
Trying to create a flat file connection with the URL of the Sharepoint list doesn't seem to work, it doesn't give me any sort of permissions error, just doesn't accept it as a valid path in the connection dialogue.
Any help appreciated.
Thanks,
Jon
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 30, 2010 at 11:45 am
Jon,
try a file system task to copy the files to a "local" location for processing.
get the UNC path to the file(s) from your IT dept.
ArkWare
December 30, 2010 at 11:59 am
Have you tried accessing the document library through a UNC path? This sometimes has issues and I've tested only with Windows Explorer not anything else (eg SSIS, text driver etc) to determine if this approach would work.
Some blogs etc on UNC paths for doc libraries
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply