Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ying Zhang How to Handle NULL Values Loaded by SSIS from Excel Files RE: How to Handle NULL Values Loaded by SSIS from Excel Files
thejackfy
SSC Enthusiast
Points: 114
More actions
April 28, 2008 at 6:12 am
#807696
Much easier way is:
Load the Excel file with First Row as Header off even it contains the header. This can ensure all the fields are read in text format. And then add a Conditional Split to skip the first row.