SQL Server Performance

How to import from a string representing a number

Discussion in 'SQL Server 2005 Integration Services' started by EMoscosoCam, Oct 29, 2007.

  1. EMoscosoCam Member

    I am importing from a comma delimited text file. A certain string column has values that represent numbers, such as "US$ 20", "30", "40 - 50". I would like to import the number, and if the cell does not contain a string representing a number (example: "I don't know"), a NULL value should be imported instead for that cell.
    Thanks a lot.
  2. jagblue New Member

Share This Page