September 14, 2006 at 12:49 pm
Hi. I'm brand new to ETL and troubleshooting an existing ETL package. The source data is a flat file and the destination is a SQL Server 2005 table. When I run the ETL, I get a warning about one particular field (LNRATE) as follows:
Warning 4 Validation warning. ACL Import, Transformation, and Load into SQL: Flat File Source [4550]: The external metadata column collection is out of synchronization with the data source columns. The column ""LNRATE"" needs to be updated in the external metadata column collection. Loan Quality Data Review ACL Import (1).dtsx 0 0
The LNRATE data in the flat file is a decimal with a varied number of digits on the right of the decimal. In the Connection Manager, I've configured the LNRATE column as a decimal with DataScale of 10. In the Flat File Source Advanced Editor, I've also used datatype decimal with scale 10. Also datatype decimal scale 10 for the output column InterestRate in the Flat File Source Advanced Editor. The SQL Server table column InterestRate is also decimal scale 10.
When I run the package the data is transfered, but why do I get this warning? Thanks for any information.
Tracey
September 14, 2006 at 2:42 pm
I changed the scale from 10 to 6. The warning is gone. Moving forward...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply