SSIS Package validation errors due to expected empty variable

0

I have a number of SSIS packages which I have deployed to SQL Server 2014. The packages take a file parameter which I place into a variable. From that rawFile variable a number of variables are derived. The packages are running fine in my development environment and are providing me with the output I am expecting. The problem I have is that I am unable to deploy the .dtsx packages using SSMS because of the following (I think expected because there is no filename yet) errors:

Error loading XXXXXXX.dtsx: Casting expression "SUBSTRING(@[User::varRawFile],19,2)" from data type "DT_WSTR" to data type "DT_I4" failed with error code 0xC00470C2.

Error loading XXXXXXX.dtsx: Error code 0x80020005 occurred attempting to convert from data type DT_WSTR to data type DT_I4.

Error saving XXXXXXX.dtsx: The expression for variable "varDataMonth" failed evaluation. There was an error in the expression.

In design mode I have DelayValidation and ValidateExternalMetadata set True and False for all objects respectively. I am able to work around the issue by deploying directly from Visual Studio but this isn't inline with my organisation's change management process.

Any help much appreciated.

sql
ssis
sql-server-2014
ssis-2012
asked on Stack Overflow Jun 6, 2016 by Chris Blake • edited Jun 7, 2016 by Chris Blake

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0