Category "etl"

Best way to compare two large files on multiple columns

I am working on a feature which will allow users to upload two csv files, write the rules to compare the rows and output a result into a file. Both files can ha

Informatica PC restart workflow with different sql query

I am using Informatica PC. I have workflow which have sql query. This query like "select t1, t2, t3 from table where t1 between date '2020-01-01' and date '2020

SSIS Extension for Visual Studio 2022

I have downloaded and installed Visual Studio 2022. Then after click on modify Now, I want to create SSIS package, for this I have started VS22 and in "manage

Data migration for .SQB files to Snowflake

I need to migrate .SQB files to Snowflake. I have a data relay where MSSQL Server database files are saved in .SQB format (Redgate) and available via sSTP with

Empty string results in "Errors were detected in the command line arguments, please make sure all arguments are set correctly"

On a SQL 2016 Server I have a job that calls an SSIS package. That package is in a project in the SSISDB and has parameters. One of those parameters is a str

SSIS ERROR: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020

I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business In

SSIS - Connection Manager Work Offline is grayed out

I am trying to debug an SSIS package locally, but for some reason the connection manager is offline and it can't be changed. Have anyone faced this issue before

ETL Migration Solution for OceanBase to Aurora

I am looking for an ETL solution that has all the necessary components with limited hand-coding that helps to migrate data from Oceanbase DB to AWS aurora. I tr