I have gone through some of the materials posted on this topic. but didnot work out for me. I am trying to import the excel file using ssis. I have got the header details , I have to skip the header while importing. I am using following sql commad:
to import . I am able to skip the header row, but missing the 1st coumn from excel.I am not able to add the F1 column in the query . Can any know why it is not possible, because of this I am miisng the 1st column to import.
SELECT F2, F3,F4, F5
where (f2is not null) and (f2<>'status')
Please help me out
View Complete Post