SSIS – markwheeler.com

SSIS: Upload file to Sharepoint Document Library (revisited)

April 24, 2014 mmwheeler

A while ago I showed how to upload a file to a Sharepoint Document Library using a File Task in SSIS. Here’s another solution…Simply cut and paste the following into a Script Task in your SSIS package. This is the simple version as the local file, Sharepoint URL and service account credentials […]

Import InfoPath XML to SQL Table with SSIS

March 10, 2014 mmwheeler

Had a request to import InfoPath forms into a SQL table for consolidating reporting purposes. In this scenario the InfoPath form data is stored in the form XML itself. The InfoPath form is for tracking project activities and has 6 fields: Project Leader, Week End Date, Accomplishments, Milestones, Risks, Lessons […]

SSIS package to Send Email based on SP Task List Due Dates

February 26, 2014 mmwheeler

Had a request to send notification emails against a SharePoint Task List when the Due Dates were 90, 60, 30 and 5 days out. Steps: 0. You will need to create the 6 variables show on the left. 1. I am dropping and importing the SP List Data each time […]

SSIS transformation for Sharepoint List Adapter

July 24, 2013 mmwheeler

I was using the SSIS Sharepoint List Adapter and ran into an issue with importing calculated columns and People columns. The import process was inserting USERID;#Username into my People column in the destination database table. It was also inserting datetime;#12/12/2013 into my date fields. I found a handy script component […]

SSIS: Upload file to Sharepoint Document Library

April 17, 2013 mmwheeler

Update 4/23/2014: I have posted a new method using a Script Task. Had a request to dump a large dataset from a SQL query into a CSV file and then upload that file to a Sharepoint document library. Because the resulting file was large, I zipped the file using a […]

Downloading files from Sharepoint Library with SSIS

April 10, 2013 mmwheeler

Discovered this SSIS dataflow task called HTTPDownload. The link here is a dtsx package you can import into Visual Studio. Modify the HTTP Connection Manager with the URL of the file. Note that this has to be specific, so the source file has to be the same if we are […]