HomeForum
Welcome, Guest

What ETL software to use
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: What ETL software to use

What ETL software to use 1 year, 2 months ago #1847

  • Vincent
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
I need to load a SQLServer table with a tab delimited data file that is 420MEG in size.
Clearly DE Wizard trying to load the whole into memory dont work. What of your products will?…

Vincent

Re: What ETL software to use 1 year, 2 months ago #1848

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
I do not know what makes you think that it loads everything into memory.
We did load files more than 2 gigabites in size.

The only time when it uses a lot of memory is when puling large amount of data via ADO.
But this now it works nothing we can do about it.

If you only want to import data, Visual importer STD would be a better option.
Peter
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

If we compare to manual processing this program save more than 200 hours in month.

C Gandhi
Nesa-Canada

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top