I have a job set up that in step 1 Deletes the data from a specified table.
In step 2 I would like to have the program run a Bat file I set up. This Bat file is the BCP import.
The bat file works fine if I run it on a windows scheduler, but I figured there has to be a way to run in from with in a SQL job.
I am using SQL Manager 2010, and in there one of the command types is Operating-system command or executable program
Under this option is a box to put in the command.
But I'm unsure of the command I need to use to make this work.
Any help is appreciated.