var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Automatic import from test file
I am trying to do a import of text csv file into SQL using the import/export wizard and it works pretty well for me.
however, i need to do a schedule jobs to import these text files which are eg. day1_001.txt, day1_002.txt, day2_001.txt ....
Everday the files are created at the target PC. I will do a ftp to my SQL server and import it to the DB. How can i automate the process. How do I use DTS to schedule import of different files names?
Pls kindly advice.