June 21, 2018 at 11:11 am
Hi Team,
I have designed SSIS package which is data taken from Oracle server and imported into SQL Server. When i execute manually the package executed successfully and data also imported. But scheduling in job(via File System not imported in File System), the job getting successfully completed but data not imported in SQL server.
I suspect it is permission issue... But how to solve it? The one common login should be in both servers?? If we go wit proxy account means, the login should be in oracle server also?
or
is it driver or other problems?
June 21, 2018 at 11:30 am
How are you authenticating to the Oracle server?
June 21, 2018 at 11:34 am
Joe Torre - Thursday, June 21, 2018 11:30 AMHow are you authenticating to the Oracle server?
June 21, 2018 at 11:35 am
Using Username and Password like SQL authentication..
June 21, 2018 at 11:44 am
Does the account SQL Agent runs under have permissions to the package path?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply