Thank you Koen and Greg for the response.

I was actually able to resolve the issue.

Firstly there was no problem with the job script. Then i opened the SSIS package...