Export to CSV file Column name change

Hello

We have been working with the system in US and a strange problem has appeared.

We added some additional table exports to the existing packages that were already working and we found that in just one of the CSV file outputs from a run of that a column name has been changed form what should be its standard column name of DESCRIPTION to DESCRIPTION_2 in the header record of the CSV file. We found this as a result of the import program that uses the CSV files from the ETL runs rejecting the CSV file as invalid.

This occurs in the package named FFA Daily Change Data Processing and also in the package named FFA Full extract – all data between 1/8/2008 and 15/11/2010

These packages are basically the same except that for the Daily one filters for a specific date when extracting transactions whereas the Full extract is filtering transactions based on a date range.

The system is running Windows server 2003 R2 SP2 and MS SQL 2000 (not sure of the SP level)

Here is a screen shot of the SQL code that extracts the data from the table –

I have emailed the CSV file that was generated in the run and a copy of the Repository

Let me know if there is any other information that would assist

A

We will check this one for you.

It is strange that you are having this kind of problems.

Recently some customers reported to us problem with duplicated field names

basically if you write sql like

select
description,
description
from table

You used to get access violations

This was addressed by giving name

fieldname+fieldno to datareader field

It might have something to do with this

Peter

We have reproduced and fixed the problem
New release will be available for download on Friday

Peter

Hi Peter

Have installed the latest version and run some extracts –
Previous column with name problem resolved and all other column names look fine.
Thank you for the support in getting this resolved quickly.

A.