is there any other way u cann help me .. from the start..as i had removed spaces but same message..Or can u send me one small sample..

shaun

no... i have to taks but one is working fine and this one is not showing the fail message.

I have sequnece container which to flow task are running parrallel and...

[Execute SQL Task] Error: Executing the query "f" failed with the following error: "ORA-00900: invalid SQL statement

". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters...

i am having issues in displaying it today..

Please view the snapshot i had ulploaded

and In the message source:

(( @[User::Variable1] !=47)?("F4"): ( "Success" ))

Can you please help me out..

Shaun.

thank you its working now..:-):-)

regards

Shaun

i am able to do but how to set up.. which task failed , only only send out message with the failed variable only

i also wanted e-mail to send out which one got failed and which success

Shaun

hi kurt,

I did had the query but was the performance issues..i was looking to use ssis components such as lookup..

Shaun..

k.. thanks koen..

Shaun

ok.. but when i execute it it goes to green but when it reaches to the look up the package complets but i see the look up is still ...

It fails when it inserts from look up with match output .but

i just removed space from 1 column and when succesess but did not update as gave me...

thank you ishanan.

Regards

Shaun

Thank you koen.. so muuch for helping me out...

regards

Shaun

I am getting all the data, in my text qualifier i had "_x003C_none_x003E_" which i removed it but can anyone tell what does do..in the text quliafier

"_x003C_none_x003E_".

regards

Shaun

i had sent u an e-mail via private message..

shaun..