A simple solution would be to stop using some half-assed, unstructured software for data.  Save the file to CSV so that the formulas are resolved, then write a datastep import  which reads the data as per the agreement you have with the vendor.  If there are invalid data in there, i.e. they do not conform to the structure document, then send the file back and ask source vendor to supply a corrected file, or update the transfer specifications.  The problem is no transfer specifications/agreement and an unacceptable transfer format, much like every question raised on Excel use ... View more

I think there is no direct / good option in DI Studio to do this like Load Time Column in Table Loader Transformation. Just managed it with User Written Code Transformation. Thanks for reply. ... View more

So, it's not parameterized for the job, path and folder name are "hard coded" for each job that uses the transforamtion? You use the dopen function, check the return code. ... View more

try something like :%sysExec move c:\folder\xyz.xlsx c:\tgtfolder or you can also try X 'move c:\folder\xyz.xlsx c:\tgtfolder'; ... View more