Solved

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

Posted on 2011-09-29
2
228 Views
Last Modified: 2012-06-27
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
Comment
Question by:blossompark
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 36816205
create a "bulk insert task", and define first and last row.
0
 

Author Closing Comment

by:blossompark
ID: 36816356
Hi x-men , thanks for that.....much appreciated
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Inserting a column in a table that creates an ID and row number 4 76
Need help with a query 6 82
SQL Error - Query 6 54
denied execute as 13 55
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question