Hi,

We have solved this problem by replacing our domain ID with SQL Service account, now its working fine.

Thanks,

Thanks for reply,

can we modify directly these stored procedure sp_MSins, sp_MSupd & sp_MSdel to make small change like we need to make one parameter of sp_MSins from varchar(255) to varchar(500)!

Thanks,

Hi,

Who is the Job owner?

If it is not sa then change it to sa & try!

Jobs runs under Sql Agent Service Account!

Regards,

Hi,

Did you sync the login rsa on DB2 database on Server2?

Execute this on DB2 database

sp_change_users_login Update_one,'rsa', 'rsa'

Regards,

Hi,

Thanks for reply, any way i got the solution

I defined a local variable in the script component's & assign the value to that variable inside process_row event & then write...

Hi,

I have setup everything like Cerdentials, proxy account but still it is failing, there is something related to security which I am not able to strike, please check the error...

HI

Thanks for reply!

I have created credentials with windows Id what they provided, but I am confused with password like which password we need to enter, weather it should be windows...

Thanks all of you

I will look into the points what you mentioned to minimise the locking

Thanks,

Thanks for taking care of this..

Hi,

Check the attachement..

Thank you

hi, Thanks for reply i understand your short explaintion of how deadlock occured.

I don't have graph but i have a following detail information, I am interested to know how it...

Hi,

Thanks for your reply!

I got the solution, I have writen the code as below

Me.ReadOnlyVariables("as_of_date").Value = Trim(Row.Column0)

and set the ReadOnlyVariables property of Script component Task with variable name (as_of_date)

Thanks

Hi Greg,

Your reply gave me confidance!

Thanks

Yes I refreshed. Even i disconnected server & connected again.

Is it related with session or Is there different storage location for objects in QA