I want to use OLEDB provide in execute sql task. (Reason why not ADO.NET is that I am not able to set connection string property from a front end which is calling the package). I have requirement of calling a SP which returns a VARCHAR Output parameter.
ConnectionType - OLE DB
Connection - (1 new OLE DB Connection by choosing new connection)
SQL Source Type - Direct Input
SQL Statement - EXEC ? = dbo.USPValidateReferencePorts ? 0
In the parameter mapping tab I have added 1 output parameter mapped to one of the decalred variable.
Parameter Name - 0
Parameter size - 255
Direction - Output
Data Type - VARCHAR
Can you please assist ASAP?