Converting text file

• dorcas

  SSC Enthusiast

  Points: 112

  More actions

  July 21, 2004 at 12:34 am

  #59841

  Hi,

  I wish to convert a text file to sql format. My text file conssist of date and time. After i convert all the fields are in character type.What  should i do to convert it to sql file so that the date is in datetime type and time is also datetime type.

  I try to make my sql file the date type into datetime type but when i convert the error message appeared.

  Thanks!

  ---

  Kindest Regards,

  dorcas
  

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  July 21, 2004 at 11:41 am

  #515514

  Use the Date Time String Transformation option of the Transform Data Task in DTS.  See "DTS Transformations" in BOL.

  Greg

  Greg