March 20, 2018 at 3:33 am
Hi All, I am getting the below error when dba is trying to deploy the SSIS package in the Production environment.
The type of the value (Int32) being assigned to variables "User::dteNewMaxDate" differes from current variable type(DateTime).
The datatype of the variable is datetime.
The package was deployed successfully in the TEST environment without any error but failed in Production.
Any idea why this is happening and how this can be resolved.
March 20, 2018 at 7:11 am
kartikaya.singh - Tuesday, March 20, 2018 3:33 AMHi All, I am getting the below error when dba is trying to deploy the SSIS package in the Production environment.
The type of the value (Int32) being assigned to variables "User::dteNewMaxDate" differes from current variable type(DateTime).
The datatype of the variable is datetime.
The package was deployed successfully in the TEST environment without any error but failed in Production.
Any idea why this is happening and how this can be resolved.
Please confirm that this is a deployment error, rather than a runtime error.
March 20, 2018 at 7:16 am
Hi Phil,
Yes this is happening at the time of deployment.
March 20, 2018 at 8:32 am
kartikaya.singh - Tuesday, March 20, 2018 7:16 AMHi Phil,Yes this is happening at the time of deployment.
Wow, that is unusual. Can you also confirm that the SQL Server version in your TEST environment is the same as is in Production?
March 20, 2018 at 11:24 am
Could it be that this variable had a different type before? You may have environment(s) configured on your Production instance that are assigning a non datetime value to this variable.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy