Forum Discussion
Execute SQL Task Editor - Passing Parameters using ADO.NET instead of OLEDB
I'm working on a data migration package and find that when I use an OLEDB connection manager, I'm able to call a stored proc using SQLSourceType of Direct Input, and easily set it up to use variables...
nelcapetown With OleDB/ODBC you can use the question mark ? as parameter placeholder, in ADO.NET you can use @ named parameter like
SELECT *
FROM youTable
WHER Column = @parameter