- Posts: 9
- Thank you received: 0
access violation in advanced etl ent. 3.3.3.5
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
Please Log in or Create an account to join the conversation.
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
Please Log in or Create an account to join the conversation.
Meantime can you try version 3.3.3.6 please
Perhaps we have already fixed it
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
but the version check doesn't find a 3.3.3.6.
so i've tried to download manually, but your site tell me that
Concurrent download limit exceeded.
Please Log in or Create an account to join the conversation.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.