Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learning is a never ending thing and just one life is not enough to learn all the things you want to learn. The ocean of knowledge is very, very deep. This blog has been created for the same objective. I write on things which I come across in my daily life and feel to share it with the people across the world. The blog publish articles on SQL Server, SSIS 2005, SSIS 2008 alongwith other useful stuff which are good to know for the professional life.
Browse by Tags · View All
Google SpreadSheet API 12
YouTube API with .NET 7
PEGA Tutorials 6
PRPC Tutorials 6
Google BigQuery 6
Google Analytics API in .NET 6
Google Cloud Services 5
Core Reporting API with C# 4
Good Data API with Picasa 4
Ms-Excel function 4

Archive · View All
June 2012 17
October 2012 12
May 2012 12
August 2012 11
March 2013 10
July 2012 10
December 2011 9
January 2012 7
September 2012 6
February 2012 6

SinghVikash Blog

SSIS: Read and Export Excel data from nth Row

Nov 13 2011 12:00AM by Vikash Kumar Singh   

This post shows how we can read and export data rom excel starting from nth row.

In SSIS we can read excel data starting from any number of row. Considering a scenario we have a excel file like below screen and we need to read data of Row 3 to Row 14 for Top 10 companies we can do this in SSIS.


To do this I create an Excel Connection manager in my SSIS package. I created a Data Flow Task in the control tab. On Data Flow tab I have following components.


I have put a Data Viewer between Excel Source and Sort. Sort component has no use in my package I simply wanted to show the data in the Data Viewer. I setup my Excel source to read the data from excel file (shown in picture 1). After setting up the Excel Source I went to the Properties window and setup the OpenRowset property value to Sheet1$A3:B14. This is because I want to read the values of Top 10 Companies and their location.


After setting the OpenRowset property I run the package and it shows the 10 rows it has read from Excel file.


In second attempt I want to read the Top 10 Companies of India. To do so I setup the OpenRowset property to Sheet1$A18:B27.


After setting the OpenRowset property I run the package and it shows the 10 rows it has read from Excel file.




We can further export these data to any table or flat file we want to. This shows an example when we have a boundation to read the data from a excel file of a specific row. The same property can be setup programmatically using Script Component.


Republished from Blog by Vikash Kumar Singh [46 clicks].  Read the original version here [8 clicks].

Vikash Kumar Singh
278 · 0% · 155
1
 
0
Lifesaver
 
0
Refreshed
 
 
0
Incorrect



Submit

1  Comments  

  • I tried to do the same. Changed the OpenRowSet value to SALES$A2:D101. Now the excel source gives me an error "The external columns of component "Excel Source" are out of aync with data source..."

    I am trying to export the top(n) rows from an excel sheet to a flat file.. Need your help

    Thanks, Pankaj

    commented on Nov 16 2012 10:24AM
    pankajarora
    2845 · 0% · 3

Your Comment


Sign Up or Login to post a comment.

"SSIS: Read and Export Excel data from nth Row" rated 5 out of 5 by 1 readers
SSIS: Read and Export Excel data from nth Row , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]