C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Interview   Jobs   Projects   Offshore Development    
Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing | Talk to Us |



My Profile

Gifts

Active Members
TodayLast 7 Days more...







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 2008Member Level: DiamondRating:     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 2008Member Level: GoldRating:     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

Contact Us    Privacy Policy    Terms Of Use