Post reply

Import non-standard data from text file

  • April 14, 2003 at 3:48 am

    #159843

    I have been given a text file that contains a header record (not column headers), a footer record and detail records. The detail records can be of 4 different types with each type having a different record structure i.e. fields of different fixed lengths. Is it possible to upload this data into SQL server tables using DTS? From my experience of DTS so far it works on a one source one destination table basis. Any assistance would be appreciated.

  • April 14, 2003 at 8:28 am

    #454069

    Hi,

    Not really... in DTS you can use one source multiple times in column destinations.

    With BCP task you can skip first row and determine how many rows you need to import.

    With CAST or CONVERT function you can convert different data types to the type you have in you table.

    JFB

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

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