DTS error while loading data

  • my server SQL Server 2000 sp4. version 2040 and movig data to Oracle 10G using 10.0.2 client from Oracle.

    Does any body have an answer to this error. Tried on net but could not find any definite solution. This package is moving around 800 K records and it's a direct upload. Never seen this error before.

    Package Name: Product Import

    Package Description: (null)

    Package ID: {77F261B3-4E70-4D1E-9DE1-65B6E958482E}

    Package Version: {6A1981DB-28C8-45E7-8C00-1C7EABDFE705}

    Step Name: DTSStep_DTSDataPumpTask_2

    Execution Started: 1/7/2009 11:34:27 PM

    Error at Destination for Row number 39313. Errors encountered so far in this task: 1.

    Error Source: OraOLEDB

    Error Description:ROW-00060: Internal error: [dainsert,16]?

    Error Help File:

    Error Help Context ID:0

    PK1726B |EDNRA-NFAT-BLA HEK293T CELLS |Y|Y|US|European|Y|Y|Y|FOR IMPORT||1 ML |Standard|CAT|V28|V28|423|

    3 1 2 |||||||14|F O R I M P O R T |P K 1 7 2 6 B |||Y |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||Y ||||||||||||||||||||||||||||||||||||||||||||||||||||||||Y ||Y |Y ||E D N R A - N F A T - B L A H E K 2 9 3 T C E L L S |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||4 2 3 ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||V 2 8 ||||||1 M L |||U S |||||||||||S t a n d a r d |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||E u r o p e a n|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||C A T ||||V 2 8 |||||||||

    Execution Completed: 1/7/2009 11:37:42 PM

    SQL DBA.

  • Can you check that record and see if you have a carriage return and or linefeed within the data (presuming that you are using either or both as your row delimiter)



    Shamless self promotion - read my blog http://sirsql.net

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply