Schedule DTS to import data from Oracle to SQL

Hi, I am trying to schedule a DTS daily to get data from Oracle to SQL Serve
r
but the job are failing. It works if I manually run the DTS. I think it is
because the SQL Agent domain account doesn't have any access to Oracle
database. I don't have control over the Orcale DB. Any idea how I can solve
this problem? Any help will be greatly appreciated!
Thanks!
--
YuhongThat is most likely the problem. You could get away with
running the DTS in a task scheduler job and run that under
any windows account you want. Here's how to do run
a stored DTS package in SQL Server via VBScript.
http://www.eggheadcafe.com/articles/20030923.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.mastervb.net/home/ng/for...st10017013.aspx
"Yuhong" <Yuhong@.discussions.microsoft.com> wrote in message
news:592FEB50-7009-4D18-B0E5-9B8583159110@.microsoft.com...
> Hi, I am trying to schedule a DTS daily to get data from Oracle to SQL
> Server
> but the job are failing. It works if I manually run the DTS. I think it is
> because the SQL Agent domain account doesn't have any access to Oracle
> database. I don't have control over the Orcale DB. Any idea how I can
> solve
> this problem? Any help will be greatly appreciated!
> Thanks!
> --
> Yuhong