Export Sharepoint list data to SQL Server 2005 database

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello Everybody,

I am presently working on a project which handles much larger amount
of data. The architecture of the application demands extracting
records from the SharePoint (WSS 3.0) and insert into a SQL Server
2005 database. I need to run this job as daily basis. I am thinking of
using SSIS (SQL Server Integration Service) for this purpose. But I am
new to this technology and I'd like to know how effective this idea to
do the job.
I'd also like to know more about SharePoint's ability to handle huge
amount of data when it comes to Reporting.

Thank you,

Arun
.

Relevant Pages

  • Re: MSmerge_history delivery_time seems wrong in 2000
    ... Director of Text Mining and Database Strategy ... In SQL Server 2000 this figure appears wrong. ... Between histrory entries the delivery_time which I can only assume is ... e.t.c) jump a very large amount, even though only a small amount of ...
    (microsoft.public.sqlserver.replication)
  • Re: custom list - minimum column length
    ... > - I'm relatively new to sharepoint. ... >>width of the view and then decides for itself the amount ... >>2003 to make the entire area in which WSS places the ... >>Mike Walsh, Helsinki, Finland ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Search Performance
    ... nothing to worry about with the amount of data that you have. ... Columnist, SQL Server Professional ... However every time I perform a search I see a spike in the cpu to about 50% ... the database design is probably not optimized, but I cannot tell since I ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search Performance
    ... nothing to worry about with the amount of data that you have. ... Columnist, SQL Server Professional ... However every time I perform a search I see a spike in the cpu to about 50% ... the database design is probably not optimized, but I cannot tell since I ...
    (microsoft.public.sqlserver.server)
  • Re: Search Performance
    ... nothing to worry about with the amount of data that you have. ... Columnist, SQL Server Professional ... However every time I perform a search I see a spike in the cpu to about 50% ... the database design is probably not optimized, but I cannot tell since I ...
    (microsoft.public.sqlserver)