Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SSIS and SharePonit

5 views
Skip to first unread message

TrussworksLeo

unread,
Jan 26, 2007, 10:52:02 AM1/26/07
to
Hello All,

Does anyone in this forum know anything about SSIS? I would like to SSIS to
connect to Sharepoint and import contacts or any other data for that matter.

--
Thank You, Leo

David Mann

unread,
Jan 26, 2007, 12:17:02 PM1/26/07
to
Hello Leo,

Connecting directly to the SharePoint database is not supported - most especially
for an insert. With that said, you can do it if you like, it's just a SQL
DB. You'll just need to tear through it all to figure out the tables you
need to work with. Be careful, there is a pretty good possibility of missing
something and breaking things. You also lose the option of MS support if
you go this route and something does break.

You likely will be much better served looking into another route. The code
to handle this would be pretty straightforward - depending on your specifics.
This would also avoid any issues with irreversibly breaking things:

1. Connect to Contacts list
2. Create new SPListItem on List
3. Populate field values on ListItem from Source
4. SPListItem.Update()
5. Rinse, Lather, Repeat as necessary

There are obviously some interim steps and other niggling little details,
but that gets you going in the right direction.

Dave

toddparker

unread,
Nov 11, 2007, 8:34:03 PM11/11/07
to
can you please extand on your response for someone that has very little wss 3.0 / Visual Studio experience and is not a programer.

I have a Foxpro Database that is been exported using SSIS to a SQL database. I would like a WSS 3.0 contacts list to bve kept in sync with the SQL database so the users can view this as a sharepoint list in Outlook.

Thanks.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

toddparker

unread,
Nov 11, 2007, 8:33:54 PM11/11/07
to

Mike Walsh

unread,
Nov 11, 2007, 11:57:15 PM11/11/07
to
With this a new message (sorry, make that two new messages) and no quote
visible of any earlier messages (at least in Thunderbird) it's hard to
imagine what the response is you expect an extension too ...

Mike Walsh
WSS FAQ www.wssfaq.com / wss.collutions.com
no private e-mail questions please

Ed

unread,
Nov 12, 2007, 12:42:19 AM11/12/07
to
Todd,

The way SharePoint can deal with data (from SQL, a Web Service etc.)
being 'in sync' is using the Business Data Catalog which is part of
Office SharePoint Server 2007, not WSS.

For doing what you need to in WSS you would have to have some process on
the server that periodically updates the SharePoint list. This can be
done but you would need to program it.
HTH,
Ed Richard

"Todd PArker" <Todd PArker> wrote in message
news:20071111...@aleon.com.au:

Jerry Rasmussen

unread,
Nov 12, 2007, 9:16:59 AM11/12/07
to
You could also write custom code that updates the contact list is
SharePoint pulling the data from SQL
0 new messages