- Posts: 5
- Thank you received: 0
Advanced ETL - Standard - Partial Load
7 years 10 months ago - 2 years 2 months ago #14030
by sydney
Advanced ETL - Standard - Partial Load was created 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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
7 years 10 months ago #14033
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Advanced ETL - Standard - Partial Load
Please check the value below.
If it does not help provide us with some screen-shots and execution log.
If it does not help provide us with some screen-shots and execution log.
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
7 years 10 months ago #14034
by sydney
Replied by sydney on topic Advanced ETL - Standard - Partial Load
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
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.