Home Forums Programming Powershell SqlBulkCopy.WriteToServer not able to convert empty values to null in destination column RE: SqlBulkCopy.WriteToServer not able to convert empty values to null in destination column

  • You are going to need to explicitly specify the columns most likely to deal with the conversion issue. Chrissy's script does not handle that, you can check the comments from her blog post noted on Script Center page for an example and a bit more info.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton