{"id":231,"date":"2013-04-17T01:15:22","date_gmt":"2013-04-16T19:15:22","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=231"},"modified":"2013-04-17T01:15:22","modified_gmt":"2013-04-16T19:15:22","slug":"ssis-upload-file-to-sharepoint-document-library","status":"publish","type":"post","link":"https:\/\/www.markwheeler.com\/?p=231","title":{"rendered":"SSIS: Upload file to Sharepoint Document Library"},"content":{"rendered":"<p><span style=\"color: #000000;\"><strong>Update 4\/23\/2014: I have posted a <a href=\"http:\/\/markwheeler.com\/wordpress\/?p=367\"><span style=\"color: #000000;\">new method<\/span><\/a> using a Script Task.<\/strong><\/span><\/p>\n<p>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.<\/p>\n<p>Because the resulting file was large, I zipped the file using a custom <a href=\"http:\/\/microsoft-ssis.blogspot.com\/2012\/10\/custom-ssis-component-zip-task.html\">Zip Task<\/a>.<\/p>\n<p>To get the file from the database server&#8217;s local drive to Sharepoint I used a File System Task.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/images\/filetask.png\" alt=\"\" width=\"469\" height=\"448\" \/><\/p>\n<p>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.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/images\/source.png\" alt=\"\" width=\"485\" height=\"222\" \/><\/p>\n<p>Your source is where you saved your flat file (or zip).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/images\/dest.png\" alt=\"\" width=\"697\" height=\"248\" \/><\/p>\n<p>My destination was entered as https:\/\/mysite\/subsite\/Shared Documents. This, however, was translated into a nice UNC path.<\/p>\n<p>\\mysite@SSLDavWWWRootsubsiteShared Documentsfilename.ext<\/p>\n<p>Simple.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/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":[18,99,110],"class_list":["post-231","post","type-post","status-publish","format-standard","hentry","category-computer","category-sharepoint","category-software","tag-18","tag-sharepoint-2010","tag-ssis"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/231","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=231"}],"version-history":[{"count":0,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}