July 27, 2012 at 3:30 am
I am getting error while executing an SSIS package through batch script.
My package is having 12 Execute SQL tasks(EST). I am getting this error from the first EST.
In this task i am calling an SP with two parameters.One is input and other one is Out parameter.
Below is the error what I am getting.
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly
Thank you
Subbu
July 27, 2012 at 12:01 pm
Subbu's (7/27/2012)
I am getting error while executing an SSIS package through batch script.My package is having 12 Execute SQL tasks(EST). I am getting this error from the first EST.
In this task i am calling an SP with two parameters.One is input and other one is Out parameter.
Below is the error what I am getting.
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly
Thank you
Subbu
Check the parameter datatypes and also look for unexpected values (nulls, strings too long, empty strings, decimal values for int parameters...). check that you have the parameters in the exec sql task set correctly (I use OLEDB so my param names start with 0, next is 1, etc etc)
Does your sp work correctly outside of this package?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply