The problem is not in the EXEC method but in the configuration of the liked server. How did you configure the linked server in the "Security" section?

Do you impersonate a...

Hi Edward,

Interesting .... me too adding some info to this thread...

Found some huge numbers in CPU..

I simpy ran the query in my machine for testing. The attachment is the result...

Sleeping connections = Connect Completed ; simply a client connection with no active query to the SQL Server

As job should run on domain but here our servers are of two different domains and couldnot execute the job. The error resembles same evn after doing many changes...

Can anyone...

Any more IDEAs please...

Suggestions are appreciated...

It could be a number of issues the things i would check would be.

--Make sure you have the correct password -

-- Make sure your account has access to...

Thanks Steve for your fast reply .

my Login account is not sysadmin on the Linked Server. So am helpless regarding the same in this time. As no one to provide...

I couldn't find any SQL Error Log here in my machine...

Actually Procedure is to import data from Linked server to my production server.

PORTUSER is the Login account which has access...

Thanks for you reply CozyRoc,

But the package was created on 2005 server itself and am running this "RSExecutionLog_Update.dtsx" on my local machine.

My machine has SQL 2005 and SQL 2008 as...