Top "Etl" questions

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

Convert String to Int SSIS

I have an string of original source and into destination table It was decimal(5,2), I try to change it with …

sql-server ssis etl ssis-2012 derived-column
Auto mapping target fields from source in informatica

I hav a source structure in informatica like col1 number col2 varchar(40) col3 DATE col4 varchar(50) col5 number and my …

etl informatica-powercenter informatica
"Metadata driven" means what? I keep hearing this phrase in ETL context but could never figure it out

Appologies if I am asking a inappropraite question but I have been hearing this phrase "Metadata driven" for years but …

ssis metadata etl informatica ab-initio
Is it possible to pass parameters to a .dtsx package on the command line?

I am currently executing an SSIS package (package.dtsx) from the command line using Dtexec. This is as simple as: …

sql-server ssis etl dtexec
How to store 'fully qualified' and 'name only' file name in SSIS variable

I have an SSIS package that has a Foreach Loop container loading all .txt files in a static folder. I'm …

sql-server variables ssis etl foreach-loop-container
Cannot get SSIS Script Task to work

I feel like I am missing some configuration or something, because I have followed tons of tutorials online, but cannot …

c# sql-server ssis etl script-task
How to fix "[OData Source [56]] Error: Cannot acquire a managed connection from the run-time connection manager." error in SSIS?

I am having problem when running SSIS which extracts data from SharePoint list. SSIS Package was running fine till 2 weeks …

ssis connection odata etl sharepoint-list
Talend - generating n multiple rows from 1 row

Background: I'm using Talend to do something (I guess) that is pretty common: generating multiple rows from one. For example: …

java row etl talend
Expose Talend ETL Job as a Web Service

I am currently evaluating Talend ETL (Talend Open Studio for Data Integration). I would like to know how / if i …

etl talend data-integration