arr.nagaraj (1/26/2012)

---

couldnt understand your question exactly.

On Node A you have Default instance ( VirtualServername1) and Node B you have named instnace (VirtualServername2\instancename). You want to connect to Node...

The Browser service is started on both nodes.

Thanks, All

Do you know if a back-door exists for said issue?

Are you running the SSIS packages manually or through a SQL Server job?

The account was created in AD and granted full control permissions on the location of the .txt file and where the files are placed. Now all is fine.

Thanks everyone.

I'm a domain admin. I changed the service account to me and now FTP works from xp_cmdshell. I'll have to figure out what specific permissions the service account...

Lowell:

I see your point but in SQL 2000 the same code runs w/o the SQL Server service account having direct access to the share. When FTP is executed it...

xp_chdshell is enabled. And yes, I'm a domain admin but the destination server is in another domain. I'm passing the username and passwords in the xxxxx_ftp1.txt file.