Please find the attached pic of the DTS.

Functionality -

----------------

1) Truncate all the temporary tables at starting point of the execution

2) Source file path is given of the CSV file which will be received every after 5 mins from interface system. File will be moved once loading is finished so file path directory is always empty when the DTS is being executed.

3) File will be loaded in in database using transformation task

4) Once file is loaded P_VDMT_EXTRACT stored procedure will be executed which is responsible for some data manipulation and population of output extract table.

5) If the stored procedure throws any error then error output extract file will be generated ( LEFT SIDE ) otherwise output extract file will be generated taking data from output extract table via transformation task (RIGHT SIDE).

Now I am getting the error in step 1 itself.