September 13, 2005 at 8:00 am
I'm having a problem with a dts package that is supposed to import data from a oracle
database.The dts package kicks off fine but its not putting any data in the tables. The strange thing is if the package is ran manually it populates the tables with data Has anyone here seen this problem before? I've narrowed the problem down to whats referenced in this url http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074. I don't understand all of this article. I understand that if owner of the dts package is not in the sysadmin group that it will execute under the credentials of the sql agent proxy account. So I went in created a domain account than came back and entered that account in the sql agent proxy. I than went and created that account a logon in sql server I than went to to the database that I'm running the dts against and gave the account data reader and datawriter access. None of what I did worked so I guess the bottom line is how do users that are not sysadmins schedule a dts package that will run?
September 14, 2005 at 12:14 pm
Adrain,
When you execute the package manually, it uses your account (the one you use to log into your desktop/laptop). When you schedule it to run, it uses the service account from the server, make sure this service account has read rights to the oracle server you are importing data from.
Jules
Jules Bui
IT Operations DBA
Backup and Restore Administrator
September 14, 2005 at 1:11 pm
Thanks for the reply I did a lot of research on dts and sql services over the past week. I did not know the sql service account had to have read rights on the oracle server. I know when you first create the dts package you supply server name user name and password I thought that was all I needed to be able to pull in data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply