SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SSIS OLE DB Data Source: literal does not match format string

862207May 16 2011 — edited May 17 2011

Dear All,

this is my first post on this forum, so sorry if I choose wrong category for this question, but I stuck...

I'm using SSIS from SQL Server 2k8 R2 in Windows Server 2k8 R2. I have installed Oracle Client 10.2.0.2 32 bits and Oracle Client 10.2.0.4 64bits. I want to connect to Oracle 8i and Oracle 9i by these clients.

Unfortunately when I want to see a preview, only error occurs to me:

ORA-01861: literal does not match format string (OraOLEDB)

I have read a lot about this issue but nothing helps me (to_date, cast, convert etc.).

This is query which I use:

SELECT COMPANYID, TRANSACTIONTYPE, TRANSACTIONDATE,
 PRODUCT, PRODUCTIONSITE, BATCHNUMBER, 
BINNUMBER, QUANTITYSTOCKUNIT, QUANTITY, 
UNITOFMEASURE, TRANSACTIONCURRENCYID, COST 
FROM APPS.DW_PRODUCTION 
WHERE TRANSACTIONDATE >= '20050101' 
AND TRANSACTIONDATE &lt; '99991231'

I have investigated that the problem is with TRANSACTIONDATE column (which is VARCHAR2 data type in database).
I want also inform You that the same query in SSIS 2005 on Windows 2005 64 bits worked fine.

Could You help me to find a solution?

Thanks in advance,

Łukasz - chalunster

PS. Sorry for my english

Edited by: BluShadow on 16-May-2011 15:15
put {noformat}

{noformat} tags into the message and encoded the &lt; symbol so that it formats correctly.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2011

Added on May 16 2011

#error, #query, #sql, #windows

6 comments

1,991 views