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!
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement