Hi Sandeep,
i have another problem
My source : Flat files
Target : Sybase and datatype is Numeric(20,3)
i cant do this calculation in SSIS
((dt_numeric,20,3)SUBSTRING(STRING,44,11)) / 1000
when running SSIS job, am getting this error: [ADO NET Destination [1057]] Error: An exception has occurred during
data insertion, the message returned from the provider is: [ZZZZZ]
[Message Class: 16]
[Message State: 1]
[Transaction State: 0]
[Server Name: imalrep]
[Native Code: 245]
[ASEOLEDB]Domain error during implicit conversion of NUMERIC value ''
to a NUMERIC field.
[ZZZZZ]
[Message Class: 10]
[Message State: 0]
[Transaction State: 3]
[Server Name: imalrep]
[Native Code: 3622]
[ASEOLEDB]Domain error occurred.
commented on May 1 2012 7:30AM