Sorry I made a mistake when typing, but the correct is "\\server B\ TransferenciaArquivoSSIS\Export_File_Destino.txt"

I understood what you said, but look, the target server is outside the network. The same is in the DMZ outside the domain to access it is through local user....

Please disregard the blanks. In the package does not exist at the time was to copy and paste.

Regards,

Antonio

Yes, does.

I have put an AD account with administratives permissios to running SQL Agent and SQL Server Integration Services. Finally, I have created a proxy with this user and nothing...

Hi All,

Has someone another idea different of linked server?

Regards,

Antonio

Dear Erland,

I checked the allow inprocess, but didn't ran correct. About to use linked server, may be not, because the developer team receaved this application with OPENROWSET and ...

Dear Erland,

I have cheked it, however It has not checked

Regards,

Antonio Estima

Dear Gail,

As this query came from sql server 2000 environment, I thought the run update statisics in sql server 2008 r2 enviroment. That would solve this issue?

Thanks for your help.

Regards,

Antonio...

Dear Evil,

Let me see and understand you.

If we have a query follow:

selectw.Unidade,

w.Data,

w.Interface,

w.NomeInterface

from( select c.unidade,

c.Data,

c.Interface,

c.NomeInterface

from cad_interface c

inner join...

Dear David,

The all objects in this query are not views. They are tables.

The question is this query work very well in sql server 2000 enviroment when put it in sql...

w.unidade is int and b.unidade varchar