Hi All,
I have an SSIS package that runs fine locally on my machine however it fails when I schedule it through SQL Agent.
After spending some time and trying to understand what's going on I think I figured out the error but not sure why it's happening.
So my SSIS package loads an excel file into a SQL table, as it's failing when I schedule in agent, I tried blanking out few columns in excel and then the job runs fine. So it's basically a few columns in the file which are causing the issue which I don't understand why?
I don't think the data type is an issue because those columns would load fine when I run them manually and the SQL table gets the data it's just the automation thing where it happens.
Can someone throw some ideas here if you have experienced this before, please?
Thanks,
Sujith

