SQLScholar
Programmer
Hey all,
I have a query which worked through sql plus which i have adapted to put into SSIS.
I am getting an error though. the code is:
The error is FROM keyword not where expected.
If i remove the cols up to and including DESCRIPTION it works.
Any ideas
Dan
----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss
Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------
I have a query which worked through sql plus which i have adapted to put into SSIS.
I am getting an error though. the code is:
Code:
SELECT
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(fes_uins_instance_code || '-' || calocc_occurrence_code,'(',''),')',''),'&',''),'+',''),'/',''),' ','') as COURSE_ID, REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(fes_uins_instance_code || '-' || calocc_occurrence_code,'(',''),')',''),'&',''),'+',''),'/',''),' ','') as EXTERNAL_COURSE_KEY,
REPLACE(unit_instances.fes_long_description,'|','')|| '-' || calocc_occurrence_code as COURSE_NAME,
REPLACE(unit_instance_occurrences.long_description,'|','')|| '-' || calocc_occurrence_code as [DESCRIPTION],
to_char(unit_instance_occurrences.fes_end_date,'mm/dd/yyyy') as [END_DATE],
to_char(unit_instance_occurrences.fes_start_date,'mm/dd/yyyy') as [START_DATE]
FROM
unit_instances@ebslive,
unit_instance_occurrences@ebslive
WHERE
fes_unit_instance_code = fes_uins_instance_code and unit_instance_occurrences.fes_end_date >= (SYSDATE-30)
The error is FROM keyword not where expected.
If i remove the cols up to and including DESCRIPTION it works.
Any ideas
Dan
----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss
Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------