{"id":228,"date":"2013-04-10T17:34:24","date_gmt":"2013-04-10T11:34:24","guid":{"rendered":"http:\/\/markwheeler.com\/wordpress\/?p=228"},"modified":"2013-04-10T17:34:24","modified_gmt":"2013-04-10T11:34:24","slug":"downloading-files-from-sharepoint-library-with-ssis","status":"publish","type":"post","link":"https:\/\/markwheeler.com\/?p=228","title":{"rendered":"Downloading files from Sharepoint Library with SSIS"},"content":{"rendered":"<p>Discovered this SSIS dataflow task called <a href=\"http:\/\/www.markwheeler.com\/binaries\/httpdownload.zip\">HTTPDownload<\/a>. The link here is a dtsx package you can import into Visual Studio.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"\/images\/\/httpcon2.png\" width=\"499\" height=\"312\" \/><\/p>\n<p>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 scheduling this as job to run on a regular basis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"\/images\/httpcon.png\" width=\"478\" height=\"406\" \/><\/p>\n<p>Double-click on the \u201cDownload File\u201d Control Flow and click Edit Script.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"\" src=\"\/images\/\/httpcon3.png\" width=\"402\" height=\"384\" \/><\/p>\n<p>There are two lines to modify: This is the destination on the local server to copy the files. Change these two lines accordingly and save.<\/p>\n<p>Dim filename As String = &#8220;C:TempFilename.xlsx&#8221;<\/p>\n<p>connection.DownloadFile(&#8220;C:TempFilename&#8221;, True)<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"\/images\/\/httpcon4.png\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[2,10,11],"tags":[110],"class_list":["post-228","post","type-post","status-publish","format-standard","hentry","category-computer","category-sharepoint","category-software","tag-ssis"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=228"}],"version-history":[{"count":0,"href":"https:\/\/markwheeler.com\/index.php?rest_route=\/wp\/v2\/posts\/228\/revisions"}],"wp:attachment":[{"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markwheeler.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}