Top "Etl" questions

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

How To Remove non-alpha numeric, or non-numeric characters with Hive REGEXP_EXTRACT() Function

I've been trying to figure out how to remove multiple non-alphanumeric or non-numeric characters, or return only the numeric characters …

regex hadoop hive etl
convert Excel Date Serial Number to Regular Date

I got a column called DateOfBirth in my csv file with Excel Date Serial Number Date Example: 36464 37104 35412 When i formatted …

sql sql-server tsql ssis etl
SSIS - How to access a RecordSet variable inside a Script Task

How do you access a RecordSet variable inside a Script Task?

ssis etl script-task
Easiest way to extract SharePoint list data to a separate SQL Server table?

Edited: What is the easiest way to scrape extract SharePoint list data to a separate SQL Server table? One condition: …

sharepoint etl sharepoint-api
SSIS Data Flow Task hangs on excecution of Pre-excecute phase

I have a Data Flow Task that is hanging on excecution. The flow is simple, makes two queries to different …

sql-server ssis etl
Dynamically assign filename to excel connection string

This is my very first time playing with SSIS in SQL Server 2012. I can successfully read an excel file and …

sql-server ssis sql-server-2012 etl
Why does my ODBC connection fail when running an SSIS load in Visual Studio but not when running the same package using Execute Package Utility

I'm working on a Data Mart loading package in SSIS 2012. When attempting to execute the package in Visual Studio I …

sql-server ssis etl
How to add third party libraries to Talend project?

How to add third party libraries (jar files) to a Talend project ? One more question is, Each Talend component uses …

java etl talend
What is the best way to save XML data to SQL Server?

Is there a direct route that is pretty straight forward? (i.e. can SQL Server read XML) Or, is it …

sql-server xml ado.net etl bcp
Is Alteryx an ETL tool? How it differs from SSIS?

My client want me to implement ETL process using Alteryx as they have a license of it. I am confused …

ssis etl difference alteryx