i am getting the following error:
JOCDEVLoadToServer..Into_SQL_Server: OLE DB provider error: The statement has been terminated.
whats that mean?
Jim
unknown error (To me atleast)
Moderators: chulett, rschirm, roy
unknown error (To me atleast)
Sure I need help....But who dosent?
Hi,
I guess it means that something about the OLEDB relevance is astray.
but we need to know what is the OLEDB relevance is in your case?
are you simply loading to a regular table using OLEDB stgae or are you trying to populate an OLEDB cube directly?
also, a bit more details on what your doing will help.
if your doing a simple insert via OLEDB stage did you manage to test the OLEDB connectivity successfully? (use the connection wizard)
also double check your sql being sent for annomalies (if my memory serves me there are also befor/after clauses.
IHTH
I guess it means that something about the OLEDB relevance is astray.
but we need to know what is the OLEDB relevance is in your case?
are you simply loading to a regular table using OLEDB stgae or are you trying to populate an OLEDB cube directly?
also, a bit more details on what your doing will help.
if your doing a simple insert via OLEDB stage did you manage to test the OLEDB connectivity successfully? (use the connection wizard)
also double check your sql being sent for annomalies (if my memory serves me there are also befor/after clauses.
IHTH
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
I think i found the answer when I tryied to load the file directly through SQL enterprise manager. It was a duplicate key issue.roy wrote:Hi,
I guess it means that something about the OLEDB relevance is astray.
but we need to know what is the OLEDB relevance is in your case?
are you simply loading to a regular table using OLEDB stgae or are you trying to populate an OLEDB cube directly?
also, a bit more details on what your doing will help.
if your doing a simple insert via OLEDB stage did you manage to test the OLEDB connectivity successfully? (use the connection wizard)
also double check your sql being sent for annomalies (if my memory serves me there are also befor/after clauses.
IHTH
Thanx
Jim
Sure I need help....But who dosent?
-
- Participant
- Posts: 145
- Joined: Fri May 02, 2003 9:59 am
- Location: Seattle, Washington. USA
The OLEDB stage and the SQL Server bulk load stage do not pass pass back the error from the server and will pass back these unusable messages. This problem has been reported to Ascential and there is a case for it. I have found that the best way to find out what is happening is to run the SQL Server profiler tool and trace the errors.
Shawn Ramsey
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
"It is a mistake to think you can solve any major problems just with potatoes."
-- Douglas Adams
cool ill do that next time i get crap error msgs.shawn_ramsey wrote:The OLEDB stage and the SQL Server bulk load stage do not pass pass back the error from the server and will pass back these unusable messages. This problem has been reported to Ascential and there is a case for it. I have found that the best way to find out what is happening is to run the SQL Server profiler tool and trace the errors.
Jim
Sure I need help....But who dosent?