MSSQLTips

Need logic to implement, export of data from different tables to their respective files in a single batch.. No joins, merge, nothing... just a file containing 'increment' extract of the table. a daily batch.

Simple solutiion - use BCP 1. create format file 2. use following command line: bcp.exe DBName..Table_Name in C:\Input_Filename.txt -T -f C:\FormatFile.fmt or use SQL syntax: BULK INSERT DBName..Table_Name FROM 'C:\Input_Filename.txt' WITH (FORMATFILE = 'C:\FormatFile.fmt') Done.