DSXchange

Hi Gregg, Thanks for your reply, eventually that's what i did too, i read it as varchar and inserted it as varchar.

Hi, I have a job which reads from a sequential file, trims data in a transformer, and then loads into a table (SQL Server 2005) There are some columns in the target table which are designated as float and are displaying curious behaviour. Source Value -- 000004876274.70 Target Value -- 4876274.5 Sou...

Hi Ray, Thanks for the response, since it is a fatal event and causing job to abort and reading your response, i think i can do three things, do you think there should be any preference amongst them or are they all just the same? 1 - use a message handler to demote it to infromational message. - Sin...

Hi, In a parallel job, a lookup stage is using a Sybase table as a reference link, it's a sparse lookup. This job is aborting with following error - "putRecord() called on output port 1 multiple times per activation of the processing logic of the operator." Does anyone has an idea what doe...

SQLCODE for rejects is -2291, which is an error code for master-child relationship - another team is investigating the data, will keep everyone posted.

Thanks for replies.

this is the insert sql as it occurs in the oracle stage, INSERT INTO schema.table ( ACDNT_ID , ACDNT_STAT_ID , SUB_ID_CD , MBR_SFX_CD , ACDNT_DT , ACDNT_TRMNTN_DT , APLCTN_CREAT_USER_ID_CD, APLCTN_UPDT_USER_ID_CD , REC_CREAT_DT , REC_CREAT_USER_ID_CD , REC_UPDT_DT , REC_UPDT_USER_ID_CD , RPLY_BY_DT ...

Oracle stage does an upsert with user defined update and insert, apart from varchar, there are three other data types, timestamp, decimal, char. I captured the rejects using a peek stage and then using these values, successfully inserted a row via oracle interface. The values for all the columns are...

chulett wrote:I'm assuming the 'n' that were rejected were a subset of the 'x' you tried to load, yes? Have you captured/identified the rejects? Seen any common issues with them? ...

No, all records were rejected.

Yes it has requisite privileges, I am sorry, i forgot to mention it, with the same user i could insert records via oracle interface.

Hi, I have a job where i am inserting records in an oracle enterprise stage, the problem is that records do not get inserted in the table. Job finishes successfully, in the log, i can see an entry that tells me n number of records were rejected. Metadata in the job design and target table match. I c...