DSXchange

Thanks for the tip but the values returned do not seem to be of much help. LASTERR = 2004-12-18 00:07:40\CILAN|LANCEH\2\AptifyPerson_Seq_file_BulkLoad..Transformer_47: At row 10, link "LinkBulkLoadPerson"?Failed to insert the row. REJECTED = 0 REJECTEDCODE = -100 DBMSCODE blank SQLSTATE bl...

I am getting an un specified error when I use the bulk load soure. How can I determine what the actual error is.

I am new to Data Stage and we just upgraded to 7.5 We have a very simple job that read from SQL2000 and writes to SQL 2000. The job has approx 400,000 rows. IF we run the job we can watch (via task manager) and seel all the memory on the server used. When this happens the job aborts. I can run the s...

Thanks for the help. I am very new to the tools and I have noever used a hash file but I will start looking at them.
I will also research stage variables.

Thanks again.

I am inserting detail records into a table. I need to generate an increasing number for each detail that relates to the same master ID. An example would be orders. Each set of order details would have a set of sequence or line numbers. Order #1 has details 1,2,3 and order #2 has details 1,2,3. Thank...