Thanks for the reply...

ok i will set the collation at dataabase/ column level.

But my question is, what will be the collation type to accept Japanese and English character set in...

Thanks for the Reply..

Below i'm listed the down the thing wchich i have done till now & Please currect me if i'm wrong.

1. Downloaded the SQL server Plug-in from

Hi,

hey i'm sorry for the big reply...:-)

Based on this reply u can undrstnd how big problem it is for me.

Below i'm copying the log:

*****

The execution of the following DTS Package...

Thanks for the reply Ritchie...

I havent used the linked server concept here.

Once again i'm explaining everything...

DTS consists 13 Tasks(3 activeX + 10 datapump tasks)

1st step: In the first...

Thanks..

ok i will upgrade the Databse to 2005 SP2 but Please tell me the process how you find the code to clean the data.

I have to identify and replace Czech characters in the database.

( Data is commingled i.e. Chech and English data are in the same tables)

2. How this can be...

F Y I

I have already installed the Oracle ODAC .

and dont have permission to change linkserver provider from MSDAORA to OraOLEDB since there are so many other jobs using it.

My SQLserver box is 32 bit..

Still the issue is not resolved...

please help me out....

Initially we have disabled 'sa' for some reason.

so we to keep some user as a job OWNER.

So what are the permissions to be given to him?

**this job consist 4 steps

3...

Before trying to connect the server change the authentication mode of Destination to

'Sqlserver and Windows Authentication mode' in Server Properities.

Thank you

Please tell me one thing.

If SQL Services running under domain account, if he changes his account psw from outside (like, suppose psw expire after every 15 days in the domain...

Thanks for the replies...

I am waiting for the approval from appl' owner to change the SQL AGENT log on

account...

Some more inf' about the error(found this from event viewer)

The execution...

Thanks for the reply...

i have one question: is this issue having any relation with job owner?

The file is not in local mech.

It is in shared folder of other box.