converting varchar datatype to datetime

• mailrpy

  SSC Enthusiast

  Points: 159

  More actions

  November 29, 2007 at 9:28 am

  #122531

  I have a column1 in tableA which has date but it is a nvarchar datatype. In the destination table the column is a datetime datatype.am trying to convert nvarchar to (DT_DATE) datetype but since that column has ' ' in it , it is giving a type cast error.

  but when i try converting it in the management studio it works fine.

  Any help on this. Am i doing something wrong ??

• Powichrowski Marek

  Hall of Fame

  Points: 3483

  More actions

  November 29, 2007 at 2:20 pm

  #755690

  Try to use Data Conversion component from Data Flow Transformation toolbar.