We are running WIN2K SP 3 and I also tried SET XACT_ABORT ON.

I would like to avoid calling PSS for support at this time.  In an above posting, I listed...

I removed 'go' from my code and am still receiving the error-- (by the way--thanks for your assistance on this!)

still stumped..

Actually, I am truncating cs_ord and then inserting into cs_ord (typo)

cs_old_ord is a table on SQL Server

C_CHOR is a view on SQL Server of an Oracle table (

CREATE VIEW dbo.C_CHOR

 (SALES_CCN,SO,C_CHORHI_ORDER_TYPE,C_CHORHI_CHANGE_NUM,CHANGE_DATE,AMT,CHANGE_AMT,BOOK_DATE)

as

Select  SALES_CCN,SO,C_CHORHI_ORDER_TYPE,C_CHORHI_CHANGE_NUM,CHANGE_DATE,AMT,CHANGE_AMT,BOOK_DATE

from GLOV_ORAC..GLOV_PRODQ.C_CHORH

begin...

Well, here is part of my code with the transaction (if I didn't use the DTS task)

begin tran

truncate table cs_ord

go

insert into cs_order_amts_all(Order_Num, Amount)

SELECT T1.SO as Order_Num,

CASE WHEN (SUM (T1.C_CHORHI_CHANGE_NUM =...

MS DTC is started on the SQL Server.  Also, below are the registry settings for [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI 

OracleXaLib=xa73.dll

OracleSqlLib = SQLLIB.dll

OracleOciLib=ociw32.dll

Changing registry settings always makes me a bit nervous.

I can query the...

Worked great!

Thanks

Thanks!

One more thing.. how can we tell what version of MDAC is currently installed?

It seems to be working now..

Thanks for all your help!

The database that I'm trying to backup is our production and transactional database. The recovery mode is set to Full.

The database that I'm trying to backup is our production and transactional database. The recovery mode is set to Full.

Thanks for all your help!

Upon research, I realize that this table was designed poorly. Multiple apps supply the need for multiple data types on this field on the table....

I did find a page somewhere that informed me of all the .dlls I would need to install in order to run dtsrun.exe.

I would like to make this as simple...

Actually, I changed it so instead of adding 7, I add 0. I was thinking that Saturday was still weekday 6, not 7.

So if I give a login db_ddladmin database roles, then can it truncate all tables in the database? I only want a certain login to be able to truncate...

Worked Flawlessly!!

Thank you so much for your help- I greatly appreciate it!!!!!