locked
Property to handle null in Json when copy data from on premise sql server to azure sql dw? RRS feed

  • Question

  • From @sharpmukesh via Twitter

     

    Is there any property to handle null in Json when copy data from on premise sql server to azure sql dw?

    When I am doing copy activity to move data from on premise sql server to azure sql dw so in source table in any column if there are null then it is not loading the data at azure sql dw in decimal or date time columns as it is treating null as string value so is there any property we can set to treat empty string or null as null . This property is available when we bring data from blob storage or flat file system but when moving from on premise sql server I am not able to find.

    I am referring g the same property when connecting on Prem sql server as source so that when copying for those columns have null value will copy as null and it will not skip as incompatible rows since destination datatype is decimal or numeric or date time which does not take null as value or string.

     

    Thanks,

    @AzureSupport

    Wednesday, August 23, 2017 2:07 AM