I have a small issue with the datatype problems.
This is what my scenario is.
I have a global variable "Qtr" declared as "Int32" datatype.
Next, i have a ActiveXscript with VBScript Language. With the below piece of code.
All it does, it will calculate and assign the calculated value to the global variable "Qtr".
But due to some datatype conversion problem it is not displaying the Calculated value. It is showing null. But the value in
the local variable is getting displayed. Can anyone figure out what the problem is all about. I have the option of taking
the String datatype for the global variable but in the next step in the workflow , we have an stored procedure call i.e. an
execute sql task where we will be call a stored procedure EXEC sp ? where the parameter datatype is an INT in the database.
That is why i am finding problem. I have used the work around i.e. using SSIS advanced expressions and avoided the parameter mapping and all.
qYears = 3
Qtr= (currentYear - qYears) * 10 + 4
msgbox("Assigning the value to the variable")
DTSGlobalVariables("Qstart").Value = Cint(Qtr)
msgbox("Display Value in the variable")
View Complete Post