-
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.
-
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.
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|