Write out to text file using T-SQL
- by sasfrog
I am creating a basic data transfer task using TSQL where I am retrieving certain records from one database that are more recent than a given datetime value, and loading them into another database. This will happen periodically throughout the day.
It's such a small task that SSIS seems like overkill - I want to just use a scheduled task which runs…