data migration-urgent

Posted Date: 30 Jun 2008 Total Responses: 2

Posted By: satish kumar thota Member Level: Gold Points: 1

How to import excel file into sql server 2005 using SSIS 2005?
i want to import only selected rows (i.e., 5th row to 100 rows ) from excel file to sql server 2005?
Is there in option starting row and ending row in SSIS?
Give me examples on ssis

Responses

Author: Vijaya 30 Jun 2008

Member Level: Diamond

Rating:

Points: 6

Hi,
The way i see instead of putting this condition to select 5th or 20th row, blidnly get all the data into staging area in SQL Server and from there use simple stored procedures to apply your filtering logic and move it to target/main tables.

Check out the below link for more information
http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htm

Thanks -- Vj
http://dotnetvj.blogspot.com

Author: Sriram 01 Jul 2008

Member Level: Gold

Rating:

Points: 1

Excel to Sql server is Possible but we cant able to select
5 Row to 100 Row

SriramRamaswamy

Post Reply

You must Sign In to post a response.

	Next : Interview Question
	Previous : How to find the database size in live server
	Return to Discussion Forum
	Post New Message
	Category: SQL Server

Related Messages

dotNet Slackers BizTalk Adaptors Web Design

conference call