InSSIS-a data flow,Excel Source (.xlsx) --> OLEDB Destination([dbo].INPUT)
Excel had empty values in some cells
when importing data from Excel to OLEDB
then OLEDB([dbo].INPUT) had NULL values (where Excel had empty value)
Destination Table : ([dbo].INPUT)) creating column structure in like
i.e., Create table INPUT (ID int,
Name nvarchar(255) NULL,....)
So How To avoid NULL in OLEDB Table when import the Excel Data ?
It means I want empty value where NULL in [dbo].INPUT table.
Please do help.
Then it is just a few more keystrokes, you can automate to a degree with an editor macro
e.g. you copy paste your columns in a column and then apply the above expression to all (by scripting a macro).
Then you copy and paste each into the Derived Column remembering to set the add as column or perhaps replace column.
Arthur My Blog