I am keep getting error when I use CAST function in Expression.
If I run (DT_I4)("1") I got following error.
TITLE: Expression Builder
Cannot convert expression value to property type.
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.Controls.TaskUIFramework.TaskUIFrameworkSR&EvtID=CannotAssignExpressionToProperty&LinkId=20476
ADDITIONAL INFORMATION:
Cannot convert 'System.Int32' to 'System.Int64'.
BUTTONS:
OK
This says to me that the target of the expression, such as a property, is of type Int64, or DT_I8, but your value is only Int32 Try the following instead-
(DT_I8)("1")
