Solved

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

Posted on 2011-09-29
2
220 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
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

911 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now