The type of the value (Int32) being assigned to variable "User::dteNewMaxDate" differs from the current variable type (DateTime). Variables may not change type during execution. Variable types are strict, except for variables of type Object

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

  • kartikaya.singh - Tuesday, March 20, 2018 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.

    Please confirm that this is a deployment error, rather than a runtime error.


  • Hi Phil,

    Yes this is happening at the time of deployment.

  • kartikaya.singh - Tuesday, March 20, 2018 7:16 AM

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


  • 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