[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

How do I... Import SQL Data into a SharePoint list automatically

Asked by MethdsSupport in MS SharePoint, SQL Server 2005, SSIS

Hi

  I am running MOSS 2007 Ent. I have a company system running on MS SQL 2005. I am trying to find a way to import data from that SQL server into a sharepoint list. I would like to either be able to schedule the process or allow a regular user to run it at will. Currently the data comes from a stored procedure.

  I have tried several options alreayd and none seems to work well enough...

  What I have tried:
1: Datagrid mode - The user runs the report from our company system (outputed to excel), they copy and paste from excel into grid mode. This doesn't seme to be able to handle a large amount of rows...
2: Access database - Created an access database with a link to the sharepoitn list. Then created a query setup to allow the import. Then they copied and pasted from excel again. This worked but took 3 hours to paste 800 rows.

  Things I'm thinking might work:
1: SQL SSIS project - Seems like it might be able to work but I am not an experienced .NET developer so..
2: Business Data Catalog - Not sure exactly sure (a little new to MOSS) if this would work...

Any help would be greatly appreciated...
[+][-]11/05/09 07:19 AM, ID: 25750371Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/05/09 09:02 AM, ID: 25751551Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/05/09 09:28 AM, ID: 25751791Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11/06/09 06:18 AM, ID: 25759273Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]11/07/09 06:13 PM, ID: 25769114Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 - Hierarchy / EE_QW_3_20080625