We use Data Transformation Services (DTS) extensively for importing/exporting to and from text files. You can use BCP as well. In the Database, SQL Server forum I sent you a link to a sample doing an export using BCP in TSQL. If you can use fixed-length fields instead of csv files for the data transfer, your life will be made much easier because of the problem of embedded quotes in text files that often cause problems when importing csv files. If you can't avoid csv, you'll have to deal with the potential problems creatively depending upon the programs you are exchanging data with, your resource options, etc.
CSV, unfortunately, has variants, and different programs handle embedded quotes differently (or not at all). If you can avoid embedded quotes in your data, you shouldn't have too much difficulty.
Good luck!
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only