I created this job (see attached) in SQL Agent which worked fine in 2008R2 and windows 2008R2. We recently migrated to a new server and are now running Windows 2012R2 and SQL Server 2014. Now the error I receive is
“SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC Driver 11 for SQL Server]Unable to open BCP host data-file”
I have looked at other instances of this error on various websites. My question is to what is “host” in the “BCP host data-file” referring?
'bcp "EXEC Polaris.Rpt_uspOrangeBoyCirculationDataCollection" queryout "' +
the output file: SET @filePath = '\\server1.windows.sno-isle.org\Shared Folders\Information Technology\OrangeBoy\Circ\'
Is it because BCP cannot find the stored procedure or is it the output file on the server on which I am saving the file and it is probably a matter of permissions/security? Or both?
asked Jul 05, 2016 at 05:42 PM in Default
I would probably check a couple of things:
answered Jul 11, 2016 at 05:24 PM
I found I needed to add an additional "polaris" to the exec statement: EXEC Polaris.Polaris.Rpt_uspOrangeBoyCirculationDataCollection'
answered Jul 12, 2016 at 07:21 PM