Is anyone using SSIS to publish an html document to SharePoint?

Question

Is anyone using SSIS to publish an html document to SharePoint?

SQLWannabe

SSCrazy

Points: 2842
More actions
September 30, 2010 at 9:39 am

#142955

Because we have severe IT restrictions on the tools we can use, I was wondering if anyone is using SSIS to publish an html document to SharePoint?
And if so, what are the steps needed to do this?

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

jjbear11 Default port Points: 1497 More actions · Answer 1

Are you utilizing Sharepoint lists at all? Or are you just needing to be able to publish an HTML document to a general location on Sharepoint? I know that there is a Sharepoint source and destination component which will read from lists and populate to lists -- I'm in the midst of using it right now.

SQLWannabe SSCrazy Points: 2842 More actions · Answer 2

We ARE using SharePoint (SP) lists, but what we are trying to do is fire off a SSIS package from a stored procedure that will post an html document to a specific location on SP, thereby effectively posting a new webpage to SP. I tried downloading and installing SharePointListAdaptersSetup.msi, but somehow it's not appearing in my Visual Studio Sources/Destinations.

jjbear11 Default port Points: 1497 More actions · Answer 3

Within SSIS itself, you have to add the SharepointList Source/Destination adapters to your toolbox. Open your package in Visual Studio. Then navigate to Tools --> Choose Toolbox Items. Click the SSIS Data Flow Items tab, then look for the Sharepoint adapters in the list. Place the check next to them, then click OK.

You will now see the adapters in your toolbox.

SQLWannabe SSCrazy Points: 2842 More actions · Answer 4

Justin, I tried that already. I ran the .msi file to get them to appear in VS2005 (I have the BIDS version), then did exactly the same thing you just described (I actually saw it in a related post). I would assume it would appear somewhere in the list either near "SQL Server xxxxxxxx" or "Microsoft xxxxxxx". I wonder if I need to reboot completely.

valecomp27 SSC Veteran Points: 206 More actions · Answer 5

Well, Yesterday I installed the adapter and I did a test and it worked well. I only followed the instructions in the page http://msdn.microsoft.com/en-us/library/dd365137%28SQL.100%29.aspx it was so simple.

If you need help you can contact me.

SQLWannabe SSCrazy Points: 2842 More actions · Answer 6

Ah, I see what the problem appears to be........ I'm on SQL 2005, not 2008. I just read thru the list adapters Read Me file and it shows 2 requirements......... 1. .NET 3.5, got it and 2. SQL 2008, don't have it, on 2005.

jjbear11 Default port Points: 1497 More actions · Answer 7

You could try one of the earlier downloads out on Codeplex. I didn't see anything explicitly stating SQL 2005 compatability, but it's worth a shot.

valecomp27 SSC Veteran Points: 206 More actions · Answer 8

Well, dear friend, in the page http://www.codeplex.com/SQLSrvIntegrationSrv/Release/ProjectReleases.aspx?ReleaseId=17652 there is an adapter for SQL Server 2005, I think you ought to pay more attention.

I hope it resolves your problem.

Regards!!!

SQLWannabe SSCrazy Points: 2842 More actions · Answer 9

valecomp, thanks for pointing that out, I SHOULD pay more attention. I just installed it and they now appear in my Toolbox Items list. I appreciate this forum and the time you guys take to help out others. I hope this helps solve my problem, I think I'm headed in the right direction.