Transfering data to Oracle via ActiveX

  • I have a source MSSQL database and I am pushing it to Oracle -- There are several columsn in the destination and one of them is a default timestamp. when I execute the package it fails on that column not allowing nulls. I take it DTS is not doing a normal insert, and there must be a something within the script (VB) that IFNull = Default???

     

    Any help is appreciated.

    Thanks -jG


    -JG

  • We had similar problems, when we wanted to push data to a Oracle Database using a Linked Server. If we didn't include alle the columns in the insert statement (even if they had a default value) it didn't work. We now use a transfer table with all the columns. Each time we insert a row, the row is written to the destination table by a trigger. 

    -OF

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply