• Janda Nel (7/24/2013)


    Good day

    I 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