Is there a way to call a stored procedure transformation which has no input and output parameters defined in the stored procedure? Please advise.
I think the easiest way is to create a dummy mapping (first create a dummy table in the source which has columns for different data types) and then call the stored procedure in the pre-sql or post-sql for the session.