SQL Server – Loading Data from csv file with BULK INSERT

Let´s say that you have a list of clients which you would like to insert into your database. If you don´t have access to an ETL Tool (such as Oracle Data Integrator, IBM DataStage, Microsoft Integration Services…) maybe it could look like a problem, but it’s not. You can use the BULK INSERT command to … Continue reading “SQL Server – Loading Data from csv file with BULK INSERT”

NETEZZA – DATA LOAD PROCESS USING TEXT FILES

You can easily implement a loading process for you NETEZZA database, even if you don´t have access to an ETL tool. You can do it just following a few steps. Let´s say that you have a text file that needs to be loaded on the database, but you don´t have access to an ETL tool … Continue reading “NETEZZA – DATA LOAD PROCESS USING TEXT FILES”