Home Forums SQL Server 2005 SQL Server 2005 Integration Services Cannot insert the value NULL into column with IMPORT/EXPORT RE: Cannot insert the value NULL into column with IMPORT/EXPORT

  • April 28, 2017 at 1:31 pm

    #1940439

    bhavesh55 - Friday, April 28, 2017 1:13 PM

    Can you please inform what do I do if the destination table field is Amount ?
    [myColumn] == "" ? NULL(DT_WSTR, 10) : [myColumn]
    can you please provide above expression for money or numeric field ?

    Hello and welcome to the forum.
    Please note that the thread you have responded to is 7 years old. I therefore recommend that you create a brand new topic instead & describe your question there in detail.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.