SSIS Execute SQL Task Variable Parameter type problem

  • 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?

  • Your going to need to post some error messages at least to get somesort of response.

    :cool:

    "There are no problems! Only solutions that have yet to be discovered!"

  • 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