Exporting data to sql server

Results 1 to 2 of 2

Thread: Exporting data to sql server

  1. #1
    Madhu Guest

    Default Exporting data to sql server

    I am using DTS package to export a cvs format data file to sql server. In the csv file one column value is having NULL(blank) and this value is taking as "NULL"(string) in the destination table. Because of this eror saying string datatype values can&#039;t be inserted in the destination table column.<BR>How to solve this??

  2. #2
    Sivaram Jagadeesan Guest

    Default RE: Exporting data to sql server

    You can goto Transformations when you do the DTS. There you can use VBScript lanugage to find the value and if ir is "NULL" then do something or just dont include it in the IF condition.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts