Delete and Load the Table
Posted: Fri Mar 11, 2011 8:37 am
I am trying to Develop a DS process.....
1. First I need to delete the Data in the Table for a Quarter of a Year.
2. Insert records in the same Table for the same Quarter.
Since it is going to be an ongoing thing, I need to develop a DS job. Well I would like both my criteria to be satisfied in the same Job. I would like to know if I will be able to do so.
I know I can create a Delete process first and then the Insert process and call both the jobs. I would like to avoid this.
1. First I need to delete the Data in the Table for a Quarter of a Year.
2. Insert records in the same Table for the same Quarter.
Since it is going to be an ongoing thing, I need to develop a DS job. Well I would like both my criteria to be satisfied in the same Job. I would like to know if I will be able to do so.
I know I can create a Delete process first and then the Insert process and call both the jobs. I would like to avoid this.