<div>
A few points to remember:<br />

<ul>
<li>SharePoint 2003 is extremely old and very different from all of the rest. Try to upgrade.</li>
<li>User information is all based on Active Directory, you may be able to get the information you need from active directory</li>
<li>User information is found in a user table found within each content database, but that may be different for SharePoint 2003</li>
<li>SharePoint list are already in SQL. You can access the data via web services.</li>
</ul>
<br />
Good luck...
</div>


A few points to remember:

 * SharePoint 2003 is extremely old and very different from all of the rest. Try to upgrade.
 * User information is all based on Active Directory, you may be able to get the information you need from active directory
 * User information is found in a user table found within each content database, but that may be different for SharePoint 2003
 * SharePoint list are already in SQL. You can access the data via web services.


Good luck...

<div>
<div class="content wysiwyg-content">
Hello -<br />
<br />
I am trying to use SSIS to pull SharePoint lists into SQL to be used elsewhere. &nbsp;It is SharePoint 2003, but so far the same ideas that work for later versions also work for this version.<br />
<br />
I am able to pull down normal SharePoint lists through SSIS. &nbsp;However, I can't figure out how to pull the hidden User Information List from SharePoint and I need it.<br />
<br />
Does anyone know how to do this?<br />
<br />
Thank you.<br />
<br />
Tammy
</div>
</div>


Hello -

I am trying to use SSIS to pull SharePoint lists into SQL to be used elsewhere.  It is SharePoint 2003, but so far the same ideas that work for later versions also work for this version.

I am able to pull down normal SharePoint lists through SSIS.  However, I can't figure out how to pull the hidden User Information List from SharePoint and I need it.

Does anyone know how to do this?

Thank you.

Tammy

Using SSIS to pull Sharepoint's User Information List

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.