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 :-)

No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts