Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

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

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
 excel
0
blossompark
Asked:
blossompark
1 Solution
 
x-menIT super heroCommented:
create a "bulk insert task", and define first and last row.
0
 
blossomparkAuthor Commented:
Hi x-men , thanks for that.....much appreciated
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now