I'm trying to execute a stored procedure via SSIS
Error: 0xC0207014 at PO Header, OLE DB Source [59]: The SQL command requires a parameter named "@SessionID", which is not found in the parameter mapping.
But as you can see below, the variables are populated, I have mapped the parameters.
So what's going on?
Based on the screenshots, you have mapped variables to parameters. Then just try to delete and recreate the OLE DB Source.
If it still throwing an error, then use expressions instead of parameters. You can refer to the following link for more information: