July 14, 2011 at 5:47 pm
I am having a data type error between the variables I have setup in my SSIS package and the parameter mapping in my Execute SQL task and need some advice on where I am going wrong.
In my database and stored procedure the Execute SQL task is calling I have an column defined as int. My package variable is UInt32 and my Parameter mapping variable is UShort with a default size of -1 in the parameter mapping area.
In my database and stored procedure the Execut SQL task is calling I have a column defined as nvarchar(100). My package variable is String and my Parameter mapping variable is NVarchar with a size of 100.
Any thoughts on where I have gone wrong to get the error extracting the result into a variable of type DBType_UI2?
July 14, 2011 at 8:16 pm
Your going to need to post some error messages at least to get somesort of response.
July 15, 2011 at 12:07 am
Try using signed integers instead of the unsigned ones.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply