I have several stored procedures with parameters which I used to call from single sql task in SSIS 2005. I am migrating my package to 2008 and so when I copy paste the same exec statements from 2005 to 2008 sql task, it has started showing error like -
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have made confirguration exactly same as that of it was in 2005 but still same error.. I tried to google it but no luck yet...!
EXEC SP_SPROCEDURE1 1,0.2,12
EXEC SP_SPROCEDURE1 2,0.2,13
EXEC SP_SPROCEDURE1 3,0.2,14
EXEC SP_SPROCEDURE1 4,0.2,15
EXEC SP_SPROCEDURE1 5,0.2,16
this is the sample code I have put inside SQL Statement section.
Does anybody has any idea on this?