I have a SSIS package which reads an excel file and loads data into a table using script component(C#) as a source. The package runs without any errors when I manually run it on my machine and on the server. But the package fails when run as a SQL Server
I tried all the possible fixes I found on the web but still can't get it to work.
Could you shed some light on it?
View Complete Post