Link to home
Start Free TrialLog in
Avatar of JohnMac328
JohnMac328Flag for United States of America

asked on

SQl convert audit files to csv

I have to somehow convert SQL audit files to a CSV format.  The problem is I can't use  BCP which relies on xp_cmdshell.  xp_cmdshell  is disabled per security requirements.  Is there another way to accomplish this?


Thanks,

John

Avatar of ste5an
ste5an
Flag of Germany image

Please rephrase your question. Focus on a process describtion.

What is a SQL audit file? How does BCP comes into play here? What has it to do with xp_cmdshell?

btw, when I need to guess: your post is missing a MS SQL Server tag? Then you do it either in SSIS or on the command line (command shell or PowerShell).
Avatar of JohnMac328

ASKER

ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks