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)
 DTS Shedule problem

Author  Topic 

tams115
Starting Member

7 Posts

Posted - 2006-02-25 : 04:34:51
Hi Every one,

i want to transfer data from source file to oracle but when i transfer data first time text to oracle it works perfectly. but i made some entries in my source(text file) and i made a shedule n give time. but it doesnt insert the new values in oracle. but if my source is text file n target is also text file it works. but when source n destination are different it doesnt work. is there any one who can help me ? i will be thankful to u for this great kind.

mcarahul
Starting Member

11 Posts

Posted - 2006-02-28 : 00:28:27
Is it showing some error or the transformation executed successfully. Also please check the transformation. Is it pointing to the right table and settings of text file in the transformation is correct.

Rahul Sharma
Go to Top of Page
   

- Advertisement -