Do I still have to specify the parameters in the SQLStatement portion when this QueryIsStoredProcedure is set to true? I've done the parameter mapping so I'm wondering if this setting removes the need to spellout the parameters in the area. DJ Baby Anne's Biggest Fan................

If you set the IsQueryStoredProcedure property to true, you do not include the parameter markers (ADO connection) or parameter names (ADO.Net connection) in the SQL statement. See "Working with Parameters and Return Codes in the Execute SQL Task" at http://msdn.microsoft.com/en-us/library/cc280502.aspx .Carla Sabotta

Got it working. I even have multiple output parameters too. They work on 0 based index system.DJ Baby Anne's Biggest Fan................