SSIS: Upload file to Sharepoint Document Library

 Computer, Sharepoint, Software  Comments Off on SSIS: Upload file to Sharepoint Document Library
Apr 172013

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 custom Zip Task.

To get the file from the database server’s local drive to Sharepoint I used a File System Task.

The only thing to configure is the DestinationConnection and SourceConnection. When you click on both, you will be prompted to create those File Connection Managers.

Your source is where you saved your flat file (or zip).

My destination was entered as https://mysite/subsite/Shared Documents. This, however, was translated into a nice UNC path.

\mysite@SSLDavWWWRootsubsiteShared Documentsfilename.ext


Point to Point Bing Map from Sharepoint List

 Computer, Sharepoint, Software  Comments Off on Point to Point Bing Map from Sharepoint List
Jan 182012

Another project I’m working on is to plot Point to Point data on a map. Using Andrew Whitten’s blog post, I was able to create a Sharepoint Web Part that calls a List with location data and plot that on a Bing Map.

My list has Point A Latitude, Point A Longitude, Point B Latitude and Point B Longitude columns. These are called thru the REST interface and placed on a map via Javascript/Jquery.
I have included the source here. I also added code allowing a Title and Description for location pop-ups.

This won’t work “out of the box” for you because everything is hardcoded. But it should be enough to help anyone needing to do the same. This was built in Visual Studio 2010.