Post reply

Need help with importing Non delimeted file to a table

  • October 19, 2011 at 7:38 am

    #390650

    Can any one please help me with the below import.any help would be appreciated.

    I need to import The text file to a table.it has no line breaks or delimiters . not sure how long each charector is. The client gave me a document of the filelname and size.

    example

    field name size

    recordno 2

    name 55

    qualifier 2

    pharmcy 30

    date 8

    batch no 10

    file no 8

    batchdate 15

    and so on for 420 columns.

    The format of the data is:

    DE0 SHAIN1CVS20110901000111256720110409 and so on...

    how can I import that data into a table.

  • October 19, 2011 at 7:45 am

    #1396635

    create a flat file connection, and then change format of this to be Fixed and then setup the col breaks in the columns tab.

  • October 19, 2011 at 8:12 am

    #1396654

    I'm concerned about the no line breaks comment. This is just one long line? I don't think the flat file connection will handle that right. If not you will have to use a script task as a data source and deconstruct the data file.

    CEWII

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

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