johnr (3/19/2008)
Is it possible to use SSIS to import this same flat file if it doesn't have a ROW delimiter?I get these files which are basically text streams and they are only delimited by record.
I've written a utlity to handle it now (it's slow and difficult to manage on all my remote sites) but is there anything already in SSIS that would just delimit the row at a specified length?
Perhaps there's a different approach that doesn't require an external utility?
You can use the Bulk Insert task with a BCP format file to import fixed-length record files. You can probably do it in the data flow task as well with some transformations, although I haven't had occasion to do that myself yet.