Archives of the TeradataForum
Message Posted: Fri, 09 Jul 2004 @ 13:04:55 GMT
You will likely need to wrap your extract query with a SEL statement that concatenates everything together using the delimiter of your choice and CAST it to the maximum length you expect from each column.
If your export is variable width, FastExport will append a 2 byte character string to the beginning of each row to indicated it's length. This is used by the other Teradata utilities and useless as far as SQL Server will be concened. You can either have SQL Server ignore the first two characters (probably the easiest) or you can write an OUTMOD in C that will strip the leading two characters.
The TeradataForum website should have a link to a UNIX version that is easily modified to work with Windows. I have used the UNIX code myself to do just what I explained above.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|