none
How To avoid NULL in OLEDB Table when import the Excel Data ?

    Question

  • 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.

    Thursday, June 26, 2014 8:07 AM

Answers

All replies