SQL Enterprise Stage error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
greggknight
Premium Member
Premium Member
Posts: 120
Joined: Thu Oct 28, 2004 4:24 pm

SQL Enterprise Stage error

Post by greggknight »

SQLServer_Enterprise_12: When checking operator: The view adapter has a binding for the non-existent destination field "BUYER_ID".

When the job starts I get this message for every column in the insert list.

There is no view in this stage..
"Don't let the bull between you and the fence"

Thanks
Gregg J Knight

"Never Never Never Quit"
Winston Churchill
greggknight
Premium Member
Premium Member
Posts: 120
Joined: Thu Oct 28, 2004 4:24 pm

Post by greggknight »

Also I know the connection to the server and table are correct because I am using truncate, and all the data dissapeared the first time I ran it.
"Don't let the bull between you and the fence"

Thanks
Gregg J Knight

"Never Never Never Quit"
Winston Churchill
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

*Topic Relocated - Content Editor*
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
anu123
Premium Member
Premium Member
Posts: 143
Joined: Sun Feb 05, 2006 1:05 pm
Location: Columbus, OH, USA

Post by anu123 »

greggknight wrote:Also I know the connection to the server and table are correct because I am using truncate, and all the data dissapeared the first time I ran it.
greggknight, how this issue was resolved? I have the same issue. I saw Ray's post which says '*Topic Relocated......*', but I could find this topic in any other location/forum.

-thanks
Thank you,
Anu
Post Reply