Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

SPS2003 List items auto updated from a SQL Db Table

Asked By: Joel Gray Date: Dec 29, 2008 Category: MOSS Views: 225

SPS2003:

Does anyone know (or have an idea where to start) how to have a WSS Team
site list update itself (or scheduled) from table in a SQL dB Table?

We are building a knowledge base WSS v2.0 Site with a list that will
store data from our HELPDESK system.

We wish the list to (on a regular basis) get its data from the SQL
back-end dB from our Helpdesk application.

Is this possible, or easily do-able?

(I'm aware of the BDC in MOSS2007 - but this is SPS2003 we're still
using)

Tagged:sps2003 list items auto updated from sql db table

1 Answer Found

Answer #1 Answered By: Janell Camacho Answered On: Dec 29, 2008

Possible, but not out of the box.

In the past, I used a console application that ran on a front-end
server. The application would read the data from the database and
add/update the SharePoint list as appropriate. The application was run
via the Scheduled Tasks applet.

Didn't find what you were looking for? Find more on SPS2003 List items auto updated from a SQL Db Table Or get search suggestion and latest updates.