November 1, 2012 at 3:09 pm
Hi,
I get the following error in the Output and not sure why? Any ideas
Error: 0xC001F009 at CDT: The type of the value being assigned to variable "User::intETLPID" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Error: 0xC001C012 at Loop for each Line in each Order: ForEach Variable Mapping number 5 to variable "User::intETLPID" cannot be applied.
Warning: 0x80019002 at CDT: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "CDT.dtsx" finished: Failure.
November 1, 2012 at 3:30 pm
Without seeing the package it's a little hard to say, but it looks as if something in the package is attempting to set a variable named "User::intETLPID" to a value that is incmopatible with the data type of the varialble. If it's an integer, look through the package and see if something is trying to set it to a string.
Here's an example of a VB.Net script that sets a value to a string:
Dts.Variables("User::var_PackageVariable").Value = "Example of setting a package variable through code"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply