string truncated when outputed to file from dts
Hi
I need output string to file using DTS data
transformation,this string will be used to import data to IBM db2
Example
source sql server ,destination text
file with column x qutable with size 326
source string
select
'CONNECT TO ' + rtrim('REPLACED_WITH_SOME_VALUE') + ' USER REPLACED_WITH_SOME_VALUE USING REPLACED_WITH_SOME_VALUE;' + char(13) + char(10)+
'IMPORT FROM ' + rtrim('REPLACED_WITH_SOME_VALUE ')+ rtrim('REPLACED_WITH_SOME_VALUE ') +' OF DEL MODIFIED BY chardel"" coldel, decpt. COMMITCOUNT 1000'+char(13) + char(10)+
'MESSAGES '+ + rtrim('REPLACED_WITH_SOME_VALUE') + rtrim('REPLACED_WITH_SOME_VALUE') + ' INSERT INTO UCIT.CUST_PRICE_ENT;'+ char(13) + char(10)+
+ 'TERMINATE;'+ char(13) + char(10)
as x
string get truncated when outputed to file by DTS
Same string fully outputed to screen when run from QA
Any idea
thank you
Alex