Hello and thanks in advice
i'm evaluating advanced etl enterprise 3.3.3.5.
i created a \"map\" with
read validate transform write operations.
source is an odbc connection (ACUODBC driver).
destination is sqlserver 2008 connected via odbc.
the reader step read about 9100 records.
FIRST ISSUE:
The generated query to evaluate the number of record involved
select Count(*).......
doesn't work, sql error(obvioulsy the odbc driver involved).
Is there any way to set manually the count query?
the validation step check for null in 3 fields and if they contain null the validation step set a blank in it.
the transformation step merge 3 string field in one.
the write populate a table with transf. option set to add new and update old.
i'm executing the etl map from the gui.
When i execute the processing data window throw an access violation error: Access Violation error at 83EC8B55. Read of address 83EC8B55
PLease help me.
PS: i attach the etl map.
Fabio
