DSXchange

If you want to run the process only when retrurn code=0 then Have two links from the command activity stage . one for return code=0 , which executes rest of the processes . one for otherwise , Which just exits the process and send an email with message ( could return code=1 or other error message). ...

Thank you both .

Will explore on the options you suggested.

I was looking for ability to view data in hashed file . Data browser in the hashed file has option like FIND.

Can we give multiple conditions on multiple columns in the FIND to hit on specific record????

Can we have flexibility to query hashed file in Stage itself in future . I know we can use UV stage but i am thinking it would be good to have editor option in the hashed file stage itself . Something like this will really help for QA purpose .Easy to search combination keys or simply like sql editi...

Deva, Based on the assumption that your input value looks like DD/MM/YYYY , i made the date to get loaded into oracle. May not be the absolute solution but try this .. use the below function in the transfomer derivation of the Date field to be loaded. Field(BEGIN_DATE,'/',3,1):Field(BEGIN_DATE,'/',2...

Deva,

First of all you need to provide the input date format looks like .

It is not possible for anyone of us to provide right solution without this information.

Just a suggestion . I have similar requirement and did something as below. Achieved in Job sequence. 1) Used UserVariables activity stage(named as UV_FileDate) which passes timestamp as parameter FileDate OCONV(@DATE, "D4YMD[4,2,2]"):'':Ereplace(OCONV(@TIME,"MT"),':','') to the j...

Please post the input date format here .

Thanks for your suggestions chulett .Will try and update here

I changed FTP script as below FileTransfer.bat @echo off SET TMP=temp_script SET REMOTESITE=remoteserver_name SET USR=username SET PAS=password SET OUTFOLDER=/Outbound SET FILESPATH=ETLserverpath echo open %REMOTESITE%>%TMP% echo %USR%>>%TMP% echo %PAS%>>%TMP% echo CD %OUTFOLDER%>>%TMP% echo put %FI...

Thanks for suggestions

i will try this on monday.

I have restricted window on weekends

Thanks ray for quick response After changing as you suggested ,now the error is Routine DSU.FTPRoutine did not finish OK, return code = 'User (servername.location.company.com:(none)): open FTPserver' servername in the error is not ETL servername . Does this make anysense?? Sorry for using aliases..

I have an issue to FTP files on remote server. I am able to FTP files manually using command line sourcing the file from local drive to FTP server. Files to be FTPed to remote server are on ETL server DS Routine code Arg1=' ETL server pathname\FTP.bat' Command = 'Arg1' Call DSExecute("DOS"...

Is there any way we can align the design on canvas automatically ?

I don't see that option . SAP/BW has that option to align the process chain .

Wish Datastage has that option