×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Error in the conversion sql query

Error in the conversion sql query

Error in the conversion sql query

(OP)
Hello,
When i click "Preview" on OLE DB Source Editor (SQL QUERY) i see result - all data .
I have error only when i Execute task with query from below ( in oracle i don't have this error , i see correct result).

The error is by converting file formats
(INPUT)
TH.LOCATIONCODE->NVARCHAR2
PROP.KEY->NUMBER

Where is my mistake?

SQL QUERY

SELECT
CAST(PROP.VALUE AS VARCHAR2(80)) Nazwa_lokalizacji
FROM KSTIMBER.TIMBERENTRYHEAD TH
LEFT JOIN KSOFTV3.SYSPROPERTIES PROP
ON CAST((TH.LOCATIONCODE) AS CHAR(80))=CAST(REPLACE(PROP.KEY,'LOCATIONCODE_','') AS CHAR(80)) AND TH.CDU_ID=PROP.CDU_ID

Error below from SSIS..

SSIS package "sql_dw_load_ksoft_wbridge_pz.dtsx" starting.
Information: 0x4004300A at Load records toWBRIDGE, DTS.Pipeline: Validation phase is beginning.
Error: 0xC0202009 at Load records toWBRIDGE, ZAczytywanie z bazy danych dbmx do SSMS 1 [57642]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E14 Description: "ORA-00904: "PROP"."VALUE": invalid identifier".
Error: 0xC004706B at Load records toWBRIDGE, DTS.Pipeline: "component "ZAczytywanie z bazy danych dbmx do SSMS 1" (57642)" failed validation and returned validation status "VS_ISBROKEN".
Error: 0xC004700C at Load records toWBRIDGE, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Load records toWBRIDGE: There were errors during task validation.
SSIS package "sql_dw_load_ksoft_wbridge_pz.dtsx" finished: Success.

RE: Error in the conversion sql query

Perhaps "KEY" is a reserved word in Oracle?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close