Page 1 of 1

OLE DB provider error

Posted: Tue Oct 13, 2009 6:19 am
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.

Re: OLE DB provider error

Posted: Tue Oct 13, 2009 6:39 am
by chitravallivenkat
could you please give the SQL statement used in that stage?

Re: OLE DB provider error

Posted: Tue Oct 13, 2009 6:44 am
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.

Posted: Tue Oct 13, 2009 7:30 am
by chulett
Post your complete, unedited errors from the log.