Hi All,
My ssis package have script task with c# code. sometimes before it was running good through the sql job agent. i have changed the some datatype in the DFT and now the package got failed sometimes and sometimes is running good through the sql job agent.
Anyone assist me what happened to this. i have also given the full access on the folder to my sql job account, that my script task push the file
let me know if you need any information for that.
Thanks,
Amar Raj