05-04-2018 01:03 AM
I'm using file writer transformation in my DI job to create the .txt file. After the successful execution of the job, when I tried to open .txt file, I'm getting an error like "Invalid Physical file". Code generated by file writer transformation as follows.
data _null_; set &SYSLAST; attrib TBKPAR length = $2; attrib CRI length = $12; attrib P2KBRN length = $2; attrib CRIHIS length = $12; attrib P2KBRH length = $2; attrib SD length = $9; attrib S2KBRN length = $2; attrib XXAROL length = $8; attrib PSI length = $9; attrib HDK length = $3; file "!FSB/common/life_details_crdb_50_tmp_timestamp.txt" lrecl=1226; put @ 1 TBKPAR @ 3 CRI @ 15 P2KBRN @ 17 CRIHIS @ 29 P2KBRH @ 31 SD @ 40 S2KBRN @ 42 XXAROL @ 50 PSI @ 59 HDK ; run;
Properties of File wrtier transformation:
Appreciate if someone of you help me understand the likely cause for this issue.