The columns in my excel source contain data of different types with the column name being a string and the data in those columns being integers. Is there any way to only extract numeric data , in short I want column names to be omitted. Also the data is distributed unevenly , beggining at various rows in each column.
Thanking in advance :)
You can try to create a named range in the Excel sheet and then import only the range.
HTH.
|||Is there any other way to do it , like writing a query or so? I need help as i'm new to SSIS , any help would be appreciated
No comments:
Post a Comment