January 19, 2010 at 7:50 am
I am creating an SSIS package that is calling a stored procedure. In the Data Flow Task, I am using an OLE DB Source and I am selecting SQL Command as the data access mode. I am entering "exec stored proc name" and clicking on the Parameters button to pass it a datetime parameter. I get a message box that "The SQL statement does not contain any parameters. If I click on the Preview button, I get and error message "Procedure or function expects parameter which was not supplied."
Does anyone know what I might be missing or if there is a workaround?
January 19, 2010 at 8:30 am
Can you post the sample query that you are using for this?
Thanks...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 19, 2010 at 8:36 am
It's a user defined stored procedure.
exec dbo.spFuelSAWA_Output
One parameter @WeekEnding which is a datetime.
I might have found a work around it by creating a user defined function that will calculate the week ending date and calling the function from within the stored procedure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply