Top "Etl" questions

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

Import Excel spreadsheet columns into SQL Server database

I have an Excel spreadsheet that I want to import select columns into my SQL Server 2008 database table. The wizard …

sql-server excel sql-server-2008 import etl
MySQL - Rows to Columns

I tried to search posts, but I only found solutions for SQL Server/Access. I need a solution in MySQL (5.…

mysql sql pivot-table etl crosstab
How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (…

sql-server sql-server-2008 etl ssis
C# Dictionary get item by index

im trying to make a method which return a name of card from my Dictionary randomly. My Dictionary: First definied …

c# dictionary etl
What does 'killed' mean when a processing of a huge CSV with Python, which suddenly stops?

I have a Python script that imports a large CSV file and then counts the number of occurrences of each …

python csv etl kill
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server …

sql-server sql-server-2008 ssis etl
SSIS - the value cannot be converted because of a potential loss of data

I am relatively new to SSIS. I am trying to extract information from an Oracle database using Microsoft OLEDB for …

sql-server oracle ssis etl
How to convert result table to JSON array in MySQL

I'd like to convert result table to JSON array in MySQL using preferably only plain MySQL commands. For example with …

mysql json etl data-conversion
Copy a few of the columns of a csv file into a table

I have a CSV file with 10 columns. After creating a PostgreSQL table with 4 columns, I want to copy some of 10 …

postgresql csv copy etl
SSIS How to get part of a string by separator

I need an SSIS expression to get the left part of a string before the separator, and then put the …

sql-server ssis expression etl