Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Oracle to SQL DTS

Author  Topic 

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2006-11-10 : 09:15:26
Hi i've a oracle connection where i write the TSQL script to get columns from the oracle table and then transfer these to my SQL Data base when i select Source i get my code with the select statement, which is fine, when i select destination i see my table were i want to transfer the data to but when i select Transformations i get the error Hresult 0x80004005. How come i can't see the Transformations so i can map them,

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-10 : 09:19:36
What is "Transformations"?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

rookie_sql
Constraint Violating Yak Guru

443 Posts

Posted - 2006-11-10 : 09:25:11
Its a Tab in the DTS package setup, its ok now i know why i can't see the Transformations. I need access the server which i don't have but when i schedule the job to run it works fine.


Go to Top of Page
   

- Advertisement -