DSXchange

I just did a test it works fine i used this data input- 03/13/2010 .. output comes as 2010/03/13 use input datatype as (varchar) -10 in the transformer use this code StringToDate(DSLink3.DATE,"%mm/%dd/%yyyy") Output datatype ( DATE) go to columns tab (output stage) and edit column meta da...

what is your input ? database/file what is the datatype.? i just tested a job it works fine its a file .. actually iam doing column import of data coming from flat file... Next in transformer iam trying to convert to specific date format... is any thing i should do in column import stage for that c...

kbsuryadev wrote:sorry i forgot these % in the code

try this in the derivation

StringToDate(input,"%mm/%dd/%yyyy")

and do the same in the output as i mentioned in the other reply

i tried but same error..

kbsuryadev wrote:please post the error.

Transformer_86,0: Conversion error calling conversion routine date_from_string data may have been lost

mhester wrote:Would you please post an actual date value?

its like

12/03/2010

format

i need 2010/03/12 format...

Still error is there...

kbsuryadev wrote:what is your output(database/file)

output is file..

kbsuryadev wrote:What is the input data type/length and is the output data type (DATE) ?

input datatype is varchar. lenght not mentioned any thing.

iam trying to convert to date.

I was developing job in parallel..

Oconv and Iconv functions are not present in parallel..

thank you..

Hi All, while i was converting from varchar to date i was getting following warning. Transformer_86,0: Conversion error calling conversion routine date_from_string data may have been lost and getting ****** as output By searching the previous posts i tried input is in format 03/13/2010 and i want in...

Hi Andrw, I gave the code which youve gave in uservariable activity before start loop .. Next in start loop i gave 'delimited values' option -> value from uservariable activity. Next in command stage inside loop i gave #StartLoop.$Counter value.. Its getting same error... Is this correct approach ...

Hi andrw ,

I tried your code but it didnt worked...

Thank you..

Hi chulett,

On searching this forum i found

"Trim the final field mark from the command's output and convert the other field marks to a printable delimiter "


Can you tell me the funtion for the above statement...

thank you..

Hi chulett,

My script is reporting event to log database.it is working fine for all iterations..but for last one its getting failed..

Any suggestions..

Hi chulett, I turned off the "automatically handle option" , but the error persists.. i was using ..execute command....>user variable--->statr loop---->command---->stop.... In user variable iam giving convert(@FM,'',Execute_Command.$CommandOutput) Is this correct way to handle...