SSIS to SharePoint
How can i shove data into Sharepoint on a schedule from my SSIS package?
September 28th, 2012 10:33am

There are several Sharepoint destination components out there. Check codeplex for free ones like here. Or check out PragmaticWorks and CozyRoc for paid. Should be able to use those destination components in your data flow, and set your package up on a schedule via and Agent job. Hope that helps. Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2012 11:16am

It seems that this control will load the data into a List in SharePoint.... Is there a way to load the data as a .csv doc. into Sharepoint
September 28th, 2012 11:55am

You need to use a script task mate. Check this which gives a solution on uploading csv to sharepoint.http://btsbee.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2012 12:29pm

You need to use a script task mate. Check this which gives a solution on uploading csv to sharepoint.http://btsbee.wordpress.com/
September 28th, 2012 12:29pm

Thanks!! Dang, this is pretty far over my head but exactly what i needed...
Free Windows Admin Tool Kit Click here and download it now
September 28th, 2012 4:08pm

The SharePoint site is hosted on another machine than my ssis package is running. I presume when i set up the job to auto run every hour i will need to run the job as a user with creds inside SharePoint. Yes the file does show up when i browse the list. I have manually ran the package a few times and checked the data is up to data/correct...
October 2nd, 2012 9:52am

I ended up going into the sharepoint site, selecting a document in the Shared Document section, going to Lib. .. open with explorer, and finding the URL of that directory... Then in my ssis package I used the flat file destination with that url. and its working like a charm :)
Free Windows Admin Tool Kit Click here and download it now
October 2nd, 2012 6:14pm

Good stuff mate. Couple of questions though. Is the sharepoint site hosted on your machine or is it a remote server. Also does the the file show up on the portal when you browse the list. http://btsbee.wordpress.com/
October 2nd, 2012 6:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics