The problem I have is not getting the server name, it is adding the name of the server to an existing dataset, which in this case was the object variable...

Thanks, my problem was that the linked server on the two server had the same name, but was pointing to different servers.

Can someone please help me? I am running a 64bit server. I create a package to run in the server with the Run64BitRuntime set to false and the security set...

I am having the same issue, did you ever find a solution?

Stopping and starting…I guess that is going to have to do.

Thx STReddy

Can fn_trace_gettable be used to access the current file? It seems as if SQL buffers the current trace until it reaches the file size that was specified before it writes...