I want to use a query to export the data from a table into a tab-delimeted text file. I've tried the following...
EXEC master..xp_cmdshell 'osql -S localhost -U sa -P support -q "select * from ims_enhanced..ims_inventory" -o c:\inventory.txt'
But this just appears to save the query result set off to a text file that is not delimeted at all.
Essentially, I need to know if there is a way to perform an export of a table(s) using a query instead of the DTS wizard.
Thank you in advance for your help,
Jim Czerniak Systems Engineer