configuring ADO.NET connection manager to execute stored procedure RRS feed

  • Question

  • Hi ,

    I'm trying to configure ADO.NET connection manager to execute SP which has 2 parameters  but it errors out with the following error :

    [Execute SQL Task] Error: Executing the query " [dbo].[xyz] " failed with the following error: "Could not find stored procedure ''.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    My stored procedure has 2 input parameters ( @Startdate and @enddate)  which loads a table  based on given dates.

    Could any one guide me through process to configure ADO.NET connection manager.

    Thank you ,


    Wednesday, December 4, 2013 8:50 PM


All replies