DSXchange

Okay. Then go to "Tools". Click on "Options" and then under "Appearance", click on "Repository Tree". Then in the category customization (in the right hand side), check the "Show Jobs" button. You should be able to see the jobs after this. Let me kno...

jobs are not visible in director , manager & in designer but i can use those whatever are their on file menu. means jobs are opening can any one pls provide solution? Hi, Go to the " View " and check the " repository ". You would be able to see all the jobs in the repository...

Thanks dls, I know that the UNIX 'comm' command compares two files which can select or reject rows common to two files. But if the "Source" in the DS job is a database table, we need to do a lookup and write the records (new and existing) to two seq files and then use the UNIX command? Wil...

When you select the "Update existing rows or insert new rows" option, what it will do is: check whether the defined Primary keys are present in the target table or not. If the "key" is found, it updates all the columns you are loading. If the "key" is not found, it inse...

IslandMon wrote:What is the best method for performing bulk loads into Oracle ??

Hi,

Why don't you use sql loader?

Thanks for your reply, Ray. The job is running fine now. That was the complete error message (BRMContactAcctBDS_Job10_LoadData..X1: rows_out:Row 1 was rejected by OLE DB provider. ) You will laugh if I tell you what was the problem. By mistake I had selected a wrong column as one of the "keys&q...

Hi, I am trying to update data into a table in SQL Server 2000. In this table, there are two columns with "Datetime" as datatype. However, my source (Oracle 9i) column data format is "YYYY-MM-DD hh:mm:ss" (Time Stamp). To insert data into SQL server, I am concatenating the incomi...