oracle & DTS

[rshivagami]

Hi all,

I want to load data from a table in SQL Server 7 to one in Oracle 8.1 on Solaris.
I used the DTS package on SQLServer to do this. I have done this a great number of times before, but I have never had this problem before. I am getting 2 errors -
ORA00972 - Identifier is too long and
ORA-01740 - Missing double quote in identifier.

My table name is just 15 characters and the datatypes too match exactly.
Does anyone know where I am going wrong??

Shiva.

[akkerend]

It can also be a column name.
An initial double quote (") was found without a closing quote, for an identifier, tablename or columnname. Check the create script.

[rshivagami]

This is my Transformation script.

Function Main()
DTSDestination("CUSTOMER_CD") = CSTR(DTSSource("ORG_NO"))
DTSDestination("ORDER_NO") = DTSSource("ORDER_NO")
DTSDestination("ORDER_VERSN_NO") = DTSSource("ORDER_VERSN_NO")
DTSDestination("ORDER_CLASS_CD") = DTSSource("ORDER_CLASS_CD")
DTSDestination("ORDER_STAT_CD") = DTSSource("ORDER_STAT_CD")
DTSDestination("SERVICE_CD") = DTSSource("SERV_ABBR")
DTSDestination("REQST_DT") = DTSSource("REQST_DT")
DTSDestination("ORDER_PRCSS_DT") = DTSSource("ORDER_PRCSS_DT")
DTSDestination("SALE_REGN_CD") = DTSSource("SALE_REGN_CD")
Main = DTSTransformStat_OK
End Function

It looks perfectly OK to me.
What do you think could be wrong with it??

Shiva.


[Edited by rshivagami on 01-23-2001 at 01:01 PM]