use procedure as input in dataflow task

If we use procedure as  source in data flow task , this generally dont work in SSIS
so we have to pass

SET nocount OFF

SET fmtonly OFF

 before running the procedure

So sql command will be like this

SET nocount OFF

SET fmtonly OFF

EXEC Proc1

cheers 🙂