Phil Parkin (12/2/2010)
The title of this thread refers to columns, yet your posts refer to rows. That's an important difference - which do you mean?
For future reference, when you get an error and you want to ask the community for help resolving it, please post the text of the error message.
Ops, :-) Sorry Phil. I d'nt noticed that. I need rows not columns. But i got the solution for this.
In my data Flow task, i need to set the "OpenRowset" Custom Property in my Excel Source (right-click your Excel connection > Properties; in the Properties window, look for OpenRowset under Custom Properties). To ignore the first 2 rows in Sheet1, and import columns from A-M, i would enter the following value for OpenRowset: Sheet1$A3:M (notice, I did not specify a row number for column M. You can enter a row number if you like. Using my OLEDB Destination i got all the records to my table.
Thank You guyz for your valuable info. :-)