Problem when running an import package

18 Views

Hello!

I'm trying to run an import package but I'm running into a problem. I'm starting out with a small file, only 28 rows. I've created a transformation and conversion file and when I validate both, it validates with no error. For the amount, I put "amount=*COL(8)" because the amount is in column 8. My file is a comma delimited file.

But when I run an import package, it gives me an error - "Duplicate Columns: SIGNEDDATA".

When I try taking out "amount=*COL(8)" from the transform file - I get this error: The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (8004202c): TransformCopy 'DTSTransformation__9' conversion error: General conversion failure on column pair 1 (source column 'SIGNEDDATA' (DBTYPE_STR), destination column 'Signeddata' (DBTYPE_NUMERIC)).)

Has anyone ever encountered this before? Your help is greatly appreciated!!!!

Thanks,

Giselle