![]() How can I handle Null values in SSIS variables. Variable types are strict, except for variables of type Object. Variables may not change type during execution. The type of the value being assigned to variable "User::Units" differs from the current variable type. Variable types are strict, except for variables of type Object ![]() The type of the value being assigned to variable "User::RefrenceRange" differs from the current variable type. Therefore, when I execute my package I get the following errors: Some of the rows in the result data set have a NULL value in the RefrenceRange and Units column. I declared Results to be Int, RefrenceRange as String and Units Then I have a foreach loop that assigns Results, RefrenceRange and Units from each row to respective SSIS variables for further processing. The result set goes in an Object type variable. I have an Execute SQL Task that runs a Sproc, which brings Result(Int), RefrenceRange(String), and Units(String) in the result data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |