Before I start, I'm using SQL 2008.
I have a Excel file with email addresses that need to acts at input parameters to a Lookup transformation. I have set the Excel Source to my file and specified the email field to be the output. I have dropped the Lookup Transformation Data Flow and connected
the both. I'm going to execute a very simple stored procedure, and under the Connections section my SQL query looks like follows: EXEC Test_GetUserName ?
When I run that I get an error saying that no parameter was provided. But when I run EXEC Test_GetUserName
'firstname.lastname@example.org' everything executes great, for the obvious part that the email is hard coded. How do I pass the excel input as the parameter?
Thanks for all the help.
There is 10 types of people in the world, those that understand binary, and those that don't.
View Complete Post