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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
