I need to pass 2 dates as parameter like today's date and yesterday's date to a stored procedure. I added the variables as datetime In oledb source I am calling the stored procedure and in the parameters I mapped the variables and added Excel destination. The package executes when I hardcode the variables but fails when I pass as parameters . Appreciate your help
I presume that by "oledb source" you meant the "execute sql" task. It sounds like your variable mapping is correct so I'm wondering what your execute sql call looks like. To pass variables to a stored proc from SSIS, you need the following syntax in the SQLStatement field: exec ?,? You need a ? for each variable that you want to pass. Since you are passing 2 variables, I included 2 question marks in my example.