SQL to input a flat file
Posted on 2006-06-16
Can someone show me an example of how you would write SQL to input a flat file? is this possible? or do you have to schedule DTS job to do this? For example, if I wanted to received a monthly csv file with and load to a table is it easier for DTS to do this or is it possible to write SQL procedure to do this?