I am using SSIS 2005 to import excel files to sql server. I have a large excel file with many columns. I have one column -qty that not all rows have data for it-empty. For such rows a another column-value that i need to export is imported as NULL. If
column QTY contains a value than column Value is imported fine but if column QTY is blank Value is NULL even if it does have a value.
I have played with TypeGuessRows but it doesn't help.
View Complete Post