Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  query on bcp utility - sql-server-2000

Author  Topic  sforsasi Starting Member 1 Post Posted - 2010-08-24 : 22:01:07 SET @SQL_CMD_STRING = 'bcp ' + @TABLE + ' out "' + @BCP_PATH + '" -c -S ' + @@SERVERNAME + ' -T' EXEC [MASTER]..XP_CMDSHELL @SQL_CMD_STRING On executing the above statement with @BCP_PATH as "\\xxx\yyy\test.dat" I receive an error "Unable to open the host file". But on executing the above statement with @BCP_PATH as "\\xxx\yyy\test1.dat", the file is generated without any issues. Any thoughts why this would happen and how would I execute the command with the path as "\\xxx\yyy\test.dat" ?