February 27, 2006 at 8:02 am
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
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