i wrote that bcp commands in a batch file to automate it.....
Using SSIS, you can write a package to export the table to a text file using a dataflow, and use an Execute SQL task to delete the rows afterward.
If you don't want to use SSIS, you might want to post to the T-SQL or Tools forum.
No comments:
Post a Comment