Odd DTS Error I Have Never Seen

• iss8317

  Newbie

  Points: 7

  More actions

  April 14, 2003 at 9:27 am

  #105907

  Using a copy column function and getting the following error message:

  Datasource for Column 5 ('comments') is not available. Your provider may require that all Blob columns be rightmost in the source result set. Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done"

  Moving data from SQL Server nvarchar(255) field to Oracle LONG type

• wbeetge

  SSChasing Mays

  Points: 636

  More actions

  April 16, 2003 at 8:34 pm

  #454461

  I dont know Oracle field types : Is the LONG field type equivalent to a VARCHAR in SQL ?

• MikeMcManus

  Valued Member

  Points: 61

  More actions

  June 3, 2003 at 9:35 am

  #459575

  comments is a key word in oracle....