{"id":213,"date":"2012-10-02T22:25:55","date_gmt":"2012-10-02T22:25:55","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=213"},"modified":"2014-03-06T15:41:04","modified_gmt":"2014-03-06T15:41:04","slug":"using-ssis-to-automatically-populate-a-sharepoint-list","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/using-ssis-to-automatically-populate-a-sharepoint-list\/","title":{"rendered":"Using SSIS to Automatically Populate a SharePoint List"},"content":{"rendered":"

In my opinion, the best (and easiest) way to accomplish this goal is using SSIS packages and a component from Codeplex called Sharepoint List Source and Destination<\/a>. Ray Barley wrote a tip<\/a> regarding this component a while back and he explained how to extract data from Sharepoint. I encourage everyone to check out his tip as it explains how to install the component and has some very good tips regarding the Sharepoint Source task. In this post, we’ll go over the Destination task in more detail.<\/p>\n

Setup a Sharepoint List<\/strong><\/h3>\n

For this tip, I’m just going to set up a quick custom list. This example is done in Sharepoint 2007, but Sharepoint 2010 should be close to the same.<\/p>\n

Go to Site Actions, Create:<\/p>\n

\"SQL<\/a>
\nCustom Lists, Custom List:<\/p>\n

\"SQL<\/a>
\nFor this example, I’ll create a list called SQL Versions:
\n\"SQL<\/a>
\nOnce I have a list created, I need to create a view with custom columns that match my SQL query. For this example I need Server Name, Instance Name, and Build. To create a view click Settings, Create View:<\/p>\n

\"SQL<\/a>
\nChoose Standard View:<\/p>\n

\"SQL<\/a>
\nName the View (for this example, I’ll name it SQLVersionView and make it my default view):
\n\"SQL<\/a>
\nNext we’ll need to create custom columns. Go to Settings, List Settings:<\/p>\n

\"SQL<\/a>
\nTo create the first column click Title and rename it to Server Name:<\/p>\n

\"SQL<\/a>\"SQL<\/a>
\nClick here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In my opinion, the best (and easiest) way to accomplish this goal is using SSIS packages and a component from Codeplex called Sharepoint List Source and Destination. Ray Barley wrote a tip regarding this component a while back and he explained how to extract data from Sharepoint. I encourage everyone to check out his tip […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30,49,48],"tags":[35,106,108,60,50],"class_list":["post-213","post","type-post","status-publish","format-standard","hentry","category-business-intelligence","category-integration-services-ssis","category-sharepoint","tag-bi","tag-business-intelligence","tag-sharepoint","tag-sql-server-integration-services","tag-ssis"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/213","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=213"}],"version-history":[{"count":1,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/213\/revisions"}],"predecessor-version":[{"id":223,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/213\/revisions\/223"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}