DTS

Hi,
I created a DTS that will do the following:
Does a select on a table, then exports the results to an oracle table, however when it does and insert i tell it to :
if exists: update
if not exists: insert
it=B4s not working... can anyone help me? i am using an active script do to this "if" job for me and i am using lookups.
Does anyone know what i can do? I have searched all over the net on how to export table to an oracle database but no luck... any sites?
:)At the start of the package use an ExecuteSQL task and query I believe
SYS.ALL_TABLES. You then use PLSQL to do the Equivalent of the SQL Server
IF EXISTS(..............). The ExecuteSQL task is provider specific in
syntax.
You can then simply do your datapump afterwards. To set up the datapump
though you will need a dummy table in Oracle so you can complete the
mappings in the datapump setup. You can delete it right after. It does not
need to be the same name only the same structure. You can apply the name
afterwards by using the object model and the DestinationObjectName property
of the DataPump.
Hope this helps
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
":)" <anonymous@.discussions.microsoft.com> wrote in message
news:12f1601c3c0e8$5f926080$a601280a@.phx.gbl...
Hi,
I created a DTS that will do the following:
Does a select on a table, then exports the results to an
oracle table, however when it does and insert i tell it
to :
if exists: update
if not exists: insert
it´s not working... can anyone help me? i am using an
active script do to this "if" job for me and i am using
lookups.
Does anyone know what i can do? I have searched all over
the net on how to export table to an oracle database but
no luck... any sites?
:)