Top "Etl" questions

ETL is an acronym for Extract, Transform, and Load.

Java ETL: hard to find a suitable one

I'm looking for an embeddable Java ETL, i.e., an Extract Transform Load engine that can be called from Java …

java etl embeddable
Open Source ETL framework

I was asked to prototype two ETL frameworks. The requirements are as follows: Open Source Available to Linux Maintained Logs …

java python ruby perl etl
Is it possible to use relative paths for SSIS packages dtsConfig files?

I am trying to make our SQL Server Integration Services packages as portable as possible and the one thing that …

sql-server ssis etl
alter table then update in single statement

I have a requirement where I need to Alter (Add 2 columns) and then update the same table. Here is the …

sql sql-server database etl talend
What's the most efficient way to convert a MySQL result set to a NumPy array?

I'm using MySQLdb and Python. I have some basic queries such as this: c=db.cursor() c.execute("SELECT id, …

python numpy mysql-python etl
Why is my SSIS toolbox empty in Visual Studio 2019 community?

I installed Visual Studio 2019 Community and then installed data tools. I can open an Integration Services project but when I …

visual-studio ssis etl toolbox ssis-2019
Replace fieldnames when using DictReader

I have a test.csv file: foo,bar,foobar,barfoo 1,2,3,4 5,6,7,8 9,10,11,12 And the following CSV parser: #!/usr/bin/env python # -*…

python json csv etl
SSIS - "External table is not in the expected format" and .xls files

In a SSIS ETL transformation I'm trying to load a certain .xls file. I have several identical files with similar …

excel ssis oledb etl
DAG(directed acyclic graph) dynamic job scheduler

I need to manage a large workflow of ETL tasks, which execution depends on time, data availability or an external …

python scheduling etl directed-acyclic-graphs oozie
SQL Server Management Studio: Import quietly ignoring 99.9% of data

The Problem i'm trying to import data into a table using SQL Server Management Studio's Import Data task. It only …

sql-server sql-server-2000 etl ssms enterprise-manager