stored procedures - ssis variable syntax conflicts with mysql output variable -


I have created an SSIS package that needs to perform a MySQL SPROC with an output parameter.

The MySQL SPROC query works well with the browser.

The problem is that the @ character is used to mark the SSIS variable and it is also used as a MySQL sproc variable for the output.

I found a solution:

I Created a step that generates variable queries.

I execute direct input as a variable input rather than directly input.


Comments