Invalid Character Constant when Executing stored procedure

Five Stars

Invalid Character Constant when Executing stored procedure

Hello,

 

Using MsSQLInput component in Talend Open Studio to execute a stored procedure with context variables as parameters.

 

Command I gave is below: It however complains of Invalid Character constant.

What is wrong with this command here? 

 

Any idea of what is wrong here?

  "EXEC sp_Cleanup_Table" '"+context.Version+"','"+context.ReportStartMonth+"','"+context.ReportEndMonth+"','"+context.ReportType+"'

 TIA

Eight Stars

Re: Invalid Character Constant when Executing stored procedure

Try by switching the qoutes
"EXEC sp_Cleanup_Table '" +context.Version+"','"+context.ReportStartMonth+"','"+context.ReportEndMonth+"','"+context.ReportType+"'"

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.