{"id":367,"date":"2014-04-24T01:57:16","date_gmt":"2014-04-23T19:57:16","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=367"},"modified":"2014-04-24T01:57:16","modified_gmt":"2014-04-23T19:57:16","slug":"ssis-upload-file-to-sharepoint-document-library-revisited","status":"publish","type":"post","link":"https:\/\/www.markwheeler.com\/?p=367","title":{"rendered":"SSIS: Upload file to Sharepoint Document Library (revisited)"},"content":{"rendered":"

A while ago<\/a>\u00a0I showed how to upload a file to a Sharepoint Document Library using a File Task in SSIS.<\/p>\n

Here’s another solution…Simply\u00a0cut and paste the following into a Script Task in your SSIS package. This is the simple version as the local file,
\nSharepoint URL and service account credentials are hardcoded. You will also need to target your script task for .Net Framework 3.5<\/p>\n


\nusing System;
\nusing System.Data;
\nusing Microsoft.SqlServer.Dts.Runtime;
\nusing Microsoft.SqlServer.Dts.Tasks.ScriptTask;
\nusing System.Windows.Forms;
\nusing System.Net;
\nusing System.IO;<\/code><\/p>\n

namespace ST_99ff82c376eb40a2829b74f045a2f3be<\/p>\n

{<\/p>\n

[System.AddIn.AddIn(“ScriptMain”, Version = “1.0”, Publisher = “”, Description = “”)]
\npublic partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
\n{
\npublic void Main()
\n{
\nWebClient myWebClient;
\nstring LocalFileName;
\nstring DestinationURL;
\nbool FireAgain = true;<\/p>\n

try<\/p>\n

{<\/p>\n

myWebClient = new WebClient();
\nLocalFileName = “F:\\SomeFolder\\SomeFile.csv”;<\/p>\n

\/\/ Destination file name with year and month appended ( SomeFile_04-23-2014.csv )<\/p>\n

DestinationURL = “https:\/\/servername\/documentlibrary\/somefile_” + DateTime.Now.ToString(“MM-dd-yyyy”) + “.csv”;<\/p>\n

Console.WriteLine(LocalFileName);<\/p>\n

myWebClient.Credentials = new NetworkCredential(“username”, “password”,”domain”);
\nmyWebClient.Credentials = CredentialCache.DefaultNetworkCredentials;<\/p>\n

Dts.Events.FireInformation(0, String.Empty, String.Format(“Uploading {0} to {1}”, LocalFileName, DestinationURL), String.Empty, 0, ref FireAgain);<\/p>\n

\/\/ upload the file<\/p>\n

myWebClient.UploadFile(DestinationURL,”PUT”, LocalFileName);<\/p>\n

}
\ncatch (Exception ex)
\n{
\n\/\/ Catch and handle error
\nDts.Events.FireError(0, String.Empty, ex.Message, String.Empty, 0);
\n}
\n}
\n}
\n}<\/p>\n","protected":false},"excerpt":{"rendered":"

A while ago\u00a0I showed how to upload a file to a Sharepoint Document Library using a File Task in SSIS. Here’s another solution…Simply\u00a0cut 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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[2,10,11],"tags":[99,110],"class_list":["post-367","post","type-post","status-publish","format-standard","hentry","category-computer","category-sharepoint","category-software","tag-sharepoint-2010","tag-ssis"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=367"}],"version-history":[{"count":0,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/367\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}