I have a DTS that makes a connection to an Oracle database and truncates a table. The DTS makes a connection to the installed Oracle OLEDB ODBC driver and has 1 SQL task for testing purposes. I can successfully execute the DTS from the package, but if I schedule the DTS or execute it from command shell using DTSRUN it never stops executing.

I have gone into the Workflow Properties of the SQL Task and checked both Execute on main package thread and Close connection on completion but neither has made an impact on my job. The only issue I can think of is the Oracle database is on another domain than my SQL database. I can successfully ping the Oracle database server though, and Oracle ODBC Test connection works fine.

Any ideas?

The only issue I can see comes close really is this

http://support.microsoft.com/?kbid=290077

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ughama" <anonymous (AT) discussions (DOT) microsoft.com> wrote

and has 1 SQL task for testing purposes. I can successfully execute the DTS
from the package, but if I schedule the DTS or execute it from command shell
using DTSRUN it never stops executing.
neither has made an impact on my job. The only issue I can think of is the
Oracle database is on another domain than my SQL database. I can
successfully ping the Oracle database server though, and Oracle ODBC Test
connection works fine.

I am currently running SQL Server Enterprise edition SP 3a. The version I get when selecting @@version is: 8.00.760. I believe this is the latest and greatest SP available. Any other ideas?