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
ssharmila
Participant
Posts: 17
Joined: Wed Jun 18, 2008 3:38 am

OLE DB provider error

Post by ssharmila »

Hi,
Am getting the following warning while running the server job.

Load: OLE DB provider error: The statement has been terminated.

Please Help me in solving this...

Thanks n advance.
chitravallivenkat
Participant
Posts: 106
Joined: Thu Jun 08, 2006 8:51 am

Re: OLE DB provider error

Post by chitravallivenkat »

could you please give the SQL statement used in that stage?
ssharmila
Participant
Posts: 17
Joined: Wed Jun 18, 2008 3:38 am

Re: OLE DB provider error

Post by ssharmila »

chitravallivenkat wrote:could you please give the SQL statement used in that stage?


No sql statements in tht stage
Data is finely passing till the transformer that is before target stage.
am using MS SQL Server Load stage in target. the problem is i cant load into it. its throwing error.
sharmila
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Post your complete, unedited errors from the log.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply