If we use procedure as source in data flow task , this generally dont work in SSIS
so we have to pass
before running the procedure
So sql command will be like this
cheers :-)
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