I'm trying to create a database profile from a t-sql stored procedure. My Type is Stored Procedure Read and I clicked the Import button which opens the Database Import Wizard. Set up the connection click on Next, in the next screen I get Choose a Stored Procedure or Function. I select my stored procedure and click Next. The next screen is Choose Columns, but all I get is @RETURN_VALUE [RETURN]. My stored procedure is very simple (because this is a test) and it only returns one column and one row; select TICKET from lastticket .
Do I need to do something special with my stored procedure?