• If you data flow is complaining because it can' determine the Meta Data from the stored procedure then you could use:

    exec p_MyProcedureName WITH RESULT SETS ((myID INT NOT NULL, myField1 VARCHAR(2), myField2 DECIMAL(15,2) etc...))

    You change this for your own procedure name and field definitions.