Post reply

import text file conversion to date

  • June 1, 2005 at 11:26 am

    #164827

    I am using DTS to import a basic text file.  One of the fields has a format of YYYYMMDD but is being treated a numeric instead of a date because it appears to be an integer.  I have tried using VB in the transformation but have not had success...any ideas on how to convert this?

  • June 1, 2005 at 4:28 pm

    #562384

    In the Transformations tab of the datapump task, select the source and destination for the date column only. Then create a DateTime transform. This will allow you to specify the input and output date formats. When you've finished your datapump will have two tasks, one for the datetime column and one for all the other columns.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply