hi phil

thanks for your response,

just assume

it is a variable or just static d:\ssis\master.txt is the file to update path to each row

and then D:\ssis\individuals is for all body generated...

another way i thought

1) all source is in text file, so loop through each row and extract emailbody column then create text file, then have the location where it saved...

Hi Drew,

Thanks a lot for your input,

it is not working, you case statement,

it seems to be logically correct but when sql processing it it is applying case sattement once per...

please GSquared

help me

thank you

asitti

Sorry to ask you,

could you please assistme regarding to this query with colease.

please squared

asitti

Yes it is kind of hierarchy, but may limited to 3 levels as in my example,

even if it is more that that ignore remain

just enough for that in example...

Hi GSquared,

Thanks alot for your such an immediate repsonse,

i greatful to you,

may be my question is confusing you,

in your response it accomplished 1 & 3, but 2 is need litttle...

please share any ideasss...

Could any one please any thoughts

regards

dhani

Here it is what i am doing

thanks to all for your best ideas......

just schedule the job for every one hour then in my script (second step ) take the...

Could any one please share ideas......

Thanks

asita

just here i am adding my script task code...

Public Class ScriptMain

Public Sub Main()

Try

...

thanks rjv

i will check it and let you know

best regards

asita

How to replace a string after first occurance

i.e

string source=" " "asas" "asde"

i would like to change " " to "," after first occurnace

so my expecting output of source...

yes in my case, i need to consider this

please help me

Regards

asita