DSXchange

@kbsuryadev,, ya correct.. it was a typo.. still showing the same error.
@chulett, my source data is like this 20101007063654

Hi Guys, My Source is SAP which is having a Timestamp value in Char field. So,i am converting the Character field to Date using the below code StringToDate(Colname,"%yyyy-%mm%dd") But i am getting a warning for all the rows and the target is not getting loaded. The warning is Conversion er...

You can't in this particular scenario. Use two targets for this, one for the insert and one for the update. Yes, that does mean you need to determine which is which rather than relying on the crutch of the database doing that for you but that should be a very simple lookup. Ya chulett, Finally that...

@chulett,, Thanks removing the column for which i need to populate the value did the trick.. Now i am able to insert to the table successfully. But i need to do a upsert instead of only insert statement. When i give the update statement along with the insert statement separated by ';', it is throwin...

@chullet, in the column tabs i have 42 columns and in the query also i have 42 columns mentioned. I cross checked the query, i have 41 '?' and 1 sequencename.Nextval... So, the query is correct. @dsx999, it is a insert query,, so unable to run it as i did not have a test data with me.. One more thin...

chulett, the query i posted is a similiar one.it is a very long query.. i double checked it.. the number of columns and the '?' are matching..

Hi Guys, I am trying to create a surrogate key using the Oracle sequencer. I have given the following statement as Userdefined SQL. Insert into Table (colnam1,colnam2,,,,) values (schema.sequencename.nextval,?,?,,,,); But it is throwing me an error saying as "invalid variable/number". I am...

Thanks Guys,, that solves my problem ... Thanks all for your help...

thanks guys,, that solved my problem.. but the data coming from the source is coming in two formats..

1. 20102009
2. 20-10-2009

Can you please advise me what needs to be done. i do not want to drop any of the records..
THanks once again for your help...

Hi Guys, I am getting Data from source in a flat file. There is a column D_DATE which will have data in the format DDMMYYYY. I need to convert it to YYYY-MM-DD. I used StringToDate function but in vain. The Code i used are StringToDate(DSLink1.D_DATE,"%yyyy%mm%dd") as well as StringToDate(...

Hi, I am trying to get the rowcount of the records from a flat file. Design Flatfile ---> Transformer ---> Flatfile In transformer, am creating a new field which will contain the count of the records in the flatfile. The expression i am using is as below DSGetLinkInfo(DSJ.ME,"Jobname",&quo...

tested it succesfully.. tat fixed it..

Thanks guys,, cudn test it though.. but i think i got it...

This is what i got from director.

.AfterJob (ExecSH): Error when executing command: mv Rej.txt Rej`date +'%m%d'`.txt
*** Output from command was: ***
mv: cannot access Rej.txt

I am getting an error with ExecSH. This is what i gave After-Job Routine : ExecSH Input Value : mv Rej.txt Rej`date +'%m%d'`.txt The mv command is working fine which i have tested it. AFter the run, i am able to find the Rej.txt also which was created by the job. Can anybody shed some light on where...