Problem when running an import package

[former_member45013]

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

[former_member45013]

My import works now. Fiddled with the transform file and rearranged dimensions under mapping and it somehow worked.

[former_member45013]

Hello! Thanks for your responses!

Steve - I tried changing the header to "amount" or blank (no header) and I keep getting the same error.

Sorin - My amounts are in USD and they are not using comma as a decimal delimiter.

Any other ideas?

-Giselle

[Former Member]

Hi Giselle,

I have seen the first problem before. It occured when I had a column in my import file with the heading 'SIGNEDDATA'. The import seemed to work ok when I changed the column heading (I changed it to 'SIGNDATA').

Hope that helps.

Thanks,

Steve

[sorin_radulescu]

Hi You can not have comma delimitator and also to have numbers using comma fo decimal delimitator.

This it will cause the problem (confusion) regarding how many columns have your input file or what is the number.

Comma is a good delimitator if you have the input file with numbers in US format.

Regards

Sorin Radulescu