Janda Nel (7/24/2013)
Good dayI want to make a job step,but it must do various commands.The steps is as follows.
1.Copy a file over to another file location
2.Insert a records into a table in the database
3. Run a dtsx import script
4. Delete the original file which i have copied.
i can achieve all this,but now i have 4 steps in my job.Is it possible to make 1 step,because i have to repeat this procedure for over 380 files.It would be nice to streamline the whole process.
thanks for your help in advance.
create step 5 and create query to identify any pending and pass it to success with go to step 1 and failure to close the job.
i hope like the above user said using SSIS is easier.
Regards
Durai Nagarajan