Looking for a way I could automate a daily task where I do a flat file csv import into my db. What I do now is from db, rc the db name>tasks>import data> Flat file Source> browse to file> enter " in text qualifier> next>Change destination to SQl SERVER NATIVE CLIENT 11.0> enter SQL Server Authentication> Next> Change table name in destination>Edit Mappings> select Delete rows > next> finish> finish
How can this be automated? I'd like to hand this off to an associate but don't want him in the db to run it. Can a bat file be created and it run as a scheduled task?