Advanced ETL - Standard - Partial Load

More
7 years 10 months ago - 2 years 2 months ago #14030 by sydney
To: Sydney Luu <sydneyluu@yahoo.com>
Sent: Saturday, November 14, 2015 3:22 AM
Subject: Re: ETL and Data Integration tools: Advanced ETL - Standard

There are no limitations.

Please post your questions on our support forum.
Mike
Hello,

I recently downloaded a copy of your Advanced ETL Standard edition for evaluation.

I was able to quickly setup a transformation to load a QVD file into SQL Server. The QVD contains 1.8M (million) rows but only loaded 600 rows to the target. Is there a limitation in your trial version?

Thank you,
Sydney
Last edit: 2 years 2 months ago by admin.

Please Log in or Create an account to join the conversation.

More
7 years 10 months ago #14033 by Peter.Jonson
Please check the value below.





If it does not help provide us with some screen-shots and execution log.

Peter Jonson
ETL Developer
Attachments:

Please Log in or Create an account to join the conversation.

More
7 years 10 months ago #14034 by sydney
I am not able to reproduce this problem today. I un-installed Advanced ETL Standard last night and installed the Pro version
to do the same test. The Pro had no issue. I let it run over night and it completed in 3+ hours by loading 1.8M rows. I will be posting a new
question concerning the performance. The old log was overwritten so I can't attach it here. I did look at the log last night and saw 600 rows
were loaded to the target. In addition, in the design screen, I saw 600 in the Reader, Transformer and Writer. The option was set at "Read
all data" NOT the first 600. I checked everything last night including checking the count on the target table.

Anyway I re-installed the standard edition and repeating the same test steps I did last night today but for whatever reason, this problem did
not come up. Not sure what the difference is. If I can get this to happen again, I will come back to post log and screenshot.

Thanks

Please Log in or Create an account to join the conversation.