Created a stored procedure to eliminate a file conversion process that
was done by several .cmd files and a customized access database.



I have xp_cmdshell for the .cmd files and have used BULK INSERT command
to input the data from file into SQL server.



Now that I have massage the data to my likening in the table, I want to
export out the data into a tab delimited file.



I want to do this within the stored procedure and not through a DTS
command as my users will access this sp from our ERP window.



I read the section Export query data to file section in BOL but it talks
about bcp utility tool...looking for suggestions...





Jeff




MS Sql Server LazyDBA home page