thank you!

I have access on folder because if try this code the output is correctly generated.

EXEC master.dbo.sp_configure 'show advanced options',
1 RECONFIGURE EXEC master.dbo.sp_configure 'xp_cmdshell',
1 RECONFIGURE EXEC xp_cmdshell 'bcp...

Thank you fo reply.

But the output file :

'D:\inetpub\wwwroot\myFile\myFile_' + CONVERT (VARCHAR, YEAR(GETDATE()), 23) + '.txt'

it was not generated

SQLState = S1000, NativeError = 0
Error =...

• This reply was modified 4 years, 10 months ago by  guido1971.