In the end I got it to work. You were right, it was an issue with permissions on the c:\ but just simply not specifying a path didn't help.

I ended...

actually i ran

EXEC master.dbo.xp_cmdshell 'bcp "SELECT FirstName, LastName FROM AdventureWorks.Person.Contact ORDER BY LastName, Firstname" queryout Contacts.txt -c -T -Usa -Ppw -S[TECH-01]'

and i am getting

SQLState = 08001, NativeError = 53

Error...

Back to the original error. I think my settings are failing me.

eliminating the c:\ still gives me the same error, I am however getting a new error when i run this:

Execute master.dbo.xp_cmdshell 'bcp "SELECT FirstName, LastName FROM AdventureWorks.Person.Contact ORDER BY LastName,...

no go 🙁

I was asking about why I needed to break the bulk insert as an output string of another SP.

also thanks for the correction in code 🙂

Got it working after some research and effort it looks like this.

this is the SP that will be executed by the application

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[updateFingerPrints]

@bulkFile VARCHAR(MAX)

AS

drop table...