i have scenario to execute stored procedure as first step, this is kind of PreStep and at the end have another stored procedure for Post Step.
Once the stored Proc is executed need DBInPutTable task to process records, but the dbInputTable does not take input… any reasons on thought behind this or how this use case can be approached
Hello jusyes,
I don’t exactly understand what you would like to do. What does your PreStep procedure do? Does it produce any records? If yes you should execute it with DBExecute component and send produced records by its output port for further processing.