Post reply

importing/exporting multi-line records

  • February 27, 2006 at 8:02 am

    #365351

    DTS was always pretty good at importing data.  However, your file structure had to be pretty simple for the import to work.  Whenever I have a file with multiple lines to a record, or a complicated header/footer/batch layout, I've been forced to use a different tool to import the data.

    Is SSIS improved to handle structured files better?  I'd like to know if it is possible to migrate all of our imports to SSIS, including the files where there are complex headers/footers/batches. 

    Luke

  • February 28, 2006 at 4:04 am

    #623633

    SSIS is certainly better at this. You could import the data as a recordset with just a single field continaing a long string and then parse it out in the pipeline, probably with a conditional split in there to break out the different "portions" of the file.

    Another option would be to buy Donald Farmer's book (available at the usual places) that contains a great example of how to import files with inconsistent row metadata.

    Lots of options basically.

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

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

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