Im trying to migrate my SQL 2000 packages that′s currently working in the company production enviroment to SSIS packages. So, in the 2000 version i got the flat file from Mainframe and i had to do a trick to transform all the columns to match the same size as the example above:
1432 1138734217 1144256628<CRLF>
1432 1138734217<CRLF>
1433 1136657788 1122441177<CRLF>
1433 1125554545 1122441177<CRLF>
1433 1192925544 1122441177<CRLF>
So, when i import the file, first of all i have to transform the Text file to another texfile file fixing the size to 32..... but you can see that in the second row im receiving a CRLF and if i try to import without the trick, the preview of the ragged file show me the columns desorganized...
Someone knows how to import it without transform to another text file with fixed length?
Thanks
Cleber
Hi
Have you already tried with a Flat File Connection Manager using the Ragged Right format and the {CR}{LF} Header Row delimiter ?
I've quickly tried and it seems to be ok.
Cheers,
|||Sorry!I tried this way but the mainframe did not send a header :(
Thanks for the help!
No comments:
Post a Comment