March 2, 2009 at 8:01 pm
Hi all, i am loading excel file into my SQL Server destination. While loading i want to avoid NULL values. Is there any specific functionality for this? My excel file data looks like
Cust_US 1098
1000123 Mitchell internet sales FL US
1000124 Craig ShowroomCust TX US
1000125 Brenda On-line buyer WI US
First row is header row and from second row the actual data. When i am loading the falt file i used two different sources to acheive this. One file loads only header and another file loads actual data.
But problem with excel file is, i did not find any option called, avoid first row.
Can someone tell me the best way to do this.
Thanks for your help
Thanks
Krish
March 3, 2009 at 1:45 am
There should be no problem with excel header.
In my experience, I'm just choosing External Column Menu (Column in excel) and the column header never loaded into table in my database.
Maybe you should give the apropriate column name for your excel file, so that every column has a name.
If your excel file consists of 4 column, give each column a name, so that SSIS may recognize it
as a header.
regards
March 3, 2009 at 3:05 am
Sry, please check Excel Connection Manager.
There is an option "First row has column names". By default, this option already checked. 😀
regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply