DSXchange

Hey , I wrote a transform and it worked.So thanx for your prompt response.Thanks a lot Ray.I am going to try your response as well. This is what I wrote in the Transform FUNCTION KsDirExists(Arg1) Ans = 10 openseq Arg1 to testfile Then Ans = 'opened' Else Ans = 'not Opened' closeseq testfile RETURN(...

Hey, I havent used a whole lot of basic and hence I ask. One of my columns in the SQL server is a file path. e.g (\\ pathname\edxt\data\folder\abc.tiff) I want to check if this file path and document actually exists on the system before I transfer the data from my transformer.How can I check for tha...

I have an input table and an output table whose column definitions are already known. All the columns that match are mapped accordingly.The columns that are present in the source database and NOT present in the target, have to be set to Null. I set the derivation field using @NULL for all these colu...