dts package moving oracle data to sql 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

dts package moving oracle data to sql 2000

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?
Check this KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 and see the permissions are set properly. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Ok I read the article but I don’t understand all of this. 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 is this what I should be doing to get non sysadmin members to run there dts packages or should I be doing something else.
Anyone know how to resolve this problem
]]>