SQL Output to File foreign character problem

[beaugirl]

Hello -- I have a step where I run some SQL and Output to File. Some of characters I output have accents and such. When I run the very same SQL script in Query Analyzer with "output to file" it is correct. However, when I run the SQL using VBP, the output has various replacement characters. In both cases, the resulting file is ANSI. Is there any way to correct this?

[kinook]

Add

-u

to the 'Additional command-line options' on the Server tab of the Run SQL action to cause OSQL to generate a Unicode (UTF-16) file.

[beaugirl]

That works, thank you!