sql server dts: Executing DTS that connect to Oracle from an ASP page -- sql server dts

Executing DTS that connect to Oracle from an ASP page

gca1 NO[at]SPAM yahoo.com
12/30/2004 4:00:23 PM

sql server dts: Hi:

I have a DTS that connect to an Oracle database and transform the data
into SQL Server tables and I'm trying to creat an ASP page in a web
server to run this DTS.

I tested this DTS in my computer through the Enterprise Manager, and
it works fine (I have the Oracle Client installed), but when I execute
the DTS through the ASP page it fails in the Oracle task (I have a few
tasks before this one, and those execute fine). I create another DTS
without the Oracle Connection (pure SQL Server) and it works fine from
the ASP page, so I think the account I used has the correct privileges
to run DTS.

My question is, where do I need to install and configure the Oracle
Client? In the SQL Server? In the Web Server? In both servers?

Regards,

Re: Executing DTS that connect to Oracle from an ASP page

Allan Mitchell
12/31/2004 6:43:20 AM

Oracle client needs to be on the caller/invoker yes. DTS is a client side app.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

[quoted text, click to view]