I am facing an interesting problem which I as a novice developer am not able to solve. I hope you guys will suggest me some solution to fix this issue.
Here is the Scenario:
I am trying to integrate R.net in SSIS package and execute this SSIS package as a job.
For this I created a SSIS package with Script task, referred both Rdotnet dll and Rdotnet .nativelibrary.dll, as I was executing in 64bit machine, I added R.dll path to environment variable. Tried to execute this SSIS package from data tool and it works perfectly
fine. Then I used dtexec in cmd prompt to execute this package and it works great from here as well. With all the hope that it would work as a job I created a job in sql server 2012 to run this package(with owner sa and proxy user to run it) Here i got the
error - "Exception has been thrown by the target of an invocation." also I can see another error as the package is not able to find R.dll's native library like devtools.
I would like to thank you all in advance for suggestions and comment.