DSXchange

Set the NullFieldValue in Format tab under the default value in target sequential file. Set it to "".

If Timestamp column is having null values then correct way to read the timestamp column will be using varchar datatype and then convert it into Timestamp. If value is null then use setnull() function to set the null values.
If IsNotNull(d3) Then StringToTimestamp(d3) Else SetNull()

If Timestamp column is having null values then correct way to read the timestamp column will be using varchar datatype and then convert it into Timestamp. If value is null then use setnull() function to set the null values.

You can use Alpha() for checking A-Z & a-z and Num() function for checking 0-9 digits. I think this will help you to check any special character.

You can use Alpha() for checking A-Z & a-z and Num() function for checking 0-9 digits. I think this will help you to check any special character.

You can read the data using varchar and then convert it into Timestamp if the column value is not null.

I am looking for that script...If some one can provide some idea or sample script then it will be very helpfull.Can someone provide necessary ds command that needs to be used in script..

We have 100 jobs in dev environment and we have to move all the job in test environment. We have to export single job at a time. we cant take the export of full project at a time(This is the requirement). Is there any command or utility that can be used to take export of all the jobs(one job at a ti...

You can use stage vaaiables in Transforme to implement this logic. Compare the currect record with previous record and concate the value in one column till keys are same and then you can use Column import and remove duplicate stage to remove duplicate record and retain the last record..

You can use the following function to convert the date into desired format DD[1,2]:'-':DD[3,2]:'-':DD[5,2]:' ': DD[7,2]: ':' :DD[9,2]: ':' :DD[11,2]

*Note: Smilies disabled in post - Content Editor*

You can use 'File Name Column' option to get the filename with the file data.

Just Press the Enter at the end of the file and try to run your job.

Thnaks a lot for your valuable response.

You can use NUM function to check numerical(integer) value and Alpha function to check string values.

You can use NUM function to check numerical value and Alpha function to check string values.