Using SSIS parameters in a SQL command text in a oracle source

Question

I try to develop a SSIS Package with an oracle source that uses a parameter.

Here's is that parameter :

Here's my SQL command in the oracle source :

The problem is that the syntax doesn't work

Here's the error message :

Can you tell me what is the right syntax ?

Best regards,

J-muns · Accepted Answer · 2025-02-12 22:29:25Z

0

I have had trouble getting parameters to work with Oracle connections. The workaround is to use a 2nd variable that contains your SQL, with an expression to include the 1st variable, and then in your Source use "SQL commmand from variable" for the Data access mode.

answered Feb 12 at 22:29

J-muns

3761 gold badge4 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using SSIS parameters in a SQL command text in a oracle source

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related