MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

SPS2003 List items auto updated from a SQL Db Table

  Asked By: Joel    Date: Dec 29    Category: MOSS    Views: 1804


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



1 Answer Found

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

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.