<div>
Hi x-men , thanks for that.....much appreciated
</div>


Hi x-men , thanks for that.....much appreciated

<div>
<div class="content wysiwyg-content">
I want &nbsp;to import into a sql server 2005 database using an SSIS package from an excel file.<br />
<br />
I only want to import the section headed &quot;Old Users&quot; and ignore all other sections...<br />
Any ideas on how I can use SSIS to achieve this?<br />
Thanks<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/09_w40/506805/ssis-import-section.bmp" target="_blank" title="excel (1.4 MB)"><img alt="excel" class="file-block lazyload" style="max-width: 720px;" data-src="https://filedb.experts-exchange.com/incoming/2011/09_w40/506805/ssis-import-section.bmp" /></a>
</div>
</div>


ssis-import-section.bmp

I want  to import into a sql server 2005 database using an SSIS package from an excel file.

I only want to import the section headed "Old Users" and ignore all other sections...
Any ideas on how I can use SSIS to achieve this?
Thanks
 

importing a section of an excel sheet into Sql server 2005 using SSIS package

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.