ETL
Foreach Loop Container with Foreach File Enumerator option iterates all files twice
I am using the SSIS For开发者_JS百科each Loop Container to iterate through files with a certain pattern on a network share.[详细]
2023-03-22 04:28 分类：问答How to Create and Execute an SSIS Package on remote sql Server source and destination using EzAPI
I need to create a Console application that can copy a table from one remote sql server instance to another remote sql server instance.[详细]
2023-03-21 21:44 分类：问答SSIS ETL Design
SSIS ETL Design I\'m trying to build a ETL job. Below aremy primary design considerations One master table to track data pull and st开发者_如何学Catus[详细]
2023-03-21 09:50 分类：问答One Db type to another - SQL
If I have SQL tables tblA and tblB and they have one to many relationship between them.. can we create multiple raven db d开发者_如何学编程ocuments automatically .. Can I automatically load documents[详细]
2023-03-19 05:13 分类：问答Pentaho-kettle: Need to create ETL Jobs dynamically based on user input
In my application,开发者_如何学运维 user can specify the format of their file. Based on user input we dynamically create SSIS package.[详细]
2023-03-18 11:32 分类：问答SSIS how to import data from Paradox?
I\'m trying to import data coming from a Paradox Database (all files *.DB are located in a folder) to Sql server 2008 with SSIS 2008.[详细]
2023-03-17 14:36 分类：问答Logging with scriptella
Does anyone know how to instruct scriptella to log to catalina开发者_运维知识库 Log What should one write in etl.xml to enable logging?Scriptella is using a standard JU logging mechanism. If you want[详细]
2023-03-16 13:03 分类：问答Export odi/odsi to text files for source control
ODI is mandatory at work but any changes made to SQL are stored internally I wish to programmatically pull out all SQL from[详细]
2023-03-16 05:03 分类：问答Grails start two in-memory databases for dev/test?
Is 开发者_如何学Cthere a way to start up two in-memory databases with grails? Specifically, I\'d like to integration test my ETL process and allow reporting to be runnable in both development and test[详细]
2023-03-15 12:31 分类：问答How can I group multiples input in one output
I have an Excel like this regionstatecity开发者_运维百科 ------------------------- southstate1city1[详细]
2023-03-13 11:02 分类：问答
加载中,请稍侯......