I have a data file (.DAT file extension) that i am trying to import in a SQL table using SSIS. Each row is 600 in length and i want to import it into one column.
the way i have set the SSIS package up is:
Format: Delimited
Text Qualifier: None
header Row Delimiter: 'LF'
Header Rows to Skip: 1
It fails when i run it saying 'Text is truncated..........' and by ignoring the failure, i see that it fails at the first decimal it sees. I think what it is trying to do is look for period to end the file. I have tried the same with 'CR' as well with the same result. How can i import the entire record by skipping the decimals.
each row has a 'C' in the end that we can use to mark the end of row but i am not sure how to make it work.
Any help would be greatly appreciated