Ambigus Error:Transformer_8: OLE DB provider error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
JDionne
Participant
Posts: 342
Joined: Wed Aug 27, 2003 1:06 pm

Ambigus Error:Transformer_8: OLE DB provider error

Post by JDionne »

I am getting the following error Transformer_8: OLE DB provider error: The statement has been terminated.

my job consits of a sequential file feeding to a transformer going to a SQL server bulk loader. The job worked fine last month. The only change is that I had to add a column to the data source and data destination. The columns were added to the end and all the trnasfroms needed were added. I have rebuilt the job to no avail. If anyone has seen this please help me sort this out.
Jim
Sure I need help....But who dosent?
JDionne
Participant
Posts: 342
Joined: Wed Aug 27, 2003 1:06 pm

Post by JDionne »

Looks like it was a meta data mismatch. Always remeber to look at your meta data :)
Jim
Sure I need help....But who dosent?
Post Reply