also, in each occurence of the character, I need a counter which will increase and show me for each record of the resultset which is the occurence sequense.

explanation: I don't know the number of delimiter characters in each row (in my example, the character "," may have different number of occurences in each row).

I need to know the action behind the binary string, and not just to convert the info in binary field to text.

Any ideas?

@Emperor100

In this case, I suppose neither the file with just headers would be exported, correct?

So, what kind of privileges should be given?

Thank you, it works fine for me too.

Thank you for your answers.

The EXEC command returns the same error, I had already tried this.

I don't want to create the object on the second database, cause my query is...

Thank you very much, I have already solved the issue.

I don't intend to argue in any way, I am just trying to find a solution. And yes, I have a second option to do my job, but I would...

Sorry but this solution is not professional in all terms. Components exist within a server for some reason, and the solution is not always to remove them in order to...

Any solution from someone?

I am getting the attached messages, executing the command on SQL and CMD.

Of course I read what you said, and I checked the link.

As I said, it has nothing to do with sybase bcp command, and also the specific command brings an...

@frederico_fonseca It's not a sybase command, it's a classic dos command executed through SQL server with the xp_cmdshell command.

@Mike01 I am executing the command in one line, as it should...

Yes, it has access to this path. Also, I have given access to the bcp.exe for the SQL service and still the problem remains.