SQL Server Integration Service

Use Hadoop File System Task in SSIS to Write File into HDFS

60 views   0 comments last modified about 2 months ago SSIS hadoop hdfs

Context SQL Server Integration Service ( SSIS ) has tasks to perform operations against Hadoop, for example: Hadoop File System Task Hadoop Hive Task Hadoop Pig Task In Data Flow Task, you can also use: Hadoop HDFS Source ...

View detail

Create ETL Project with Teradata through SSIS

7315 views   2 comments last modified about 3 years ago

Infosphere DataStage is adopted as ETL (Extract, Transform, Load) tool in many Teradata based data warehousing projects. With the Teradata ODBC and .NET data providers, you can also use the BI tools from Microsoft, i.e. SSIS. In my previous post, I demonstrated how to install Teradata Tool...

View detail

Generate Formatted Excel Destination (Output) in SSIS Data Flow Task

7715 views   0 comments last modified about 4 years ago

SSIS (SQL Server Integration Service) provides a number of convenient tasks to enable data integration. Exporting data from database to Excel file is a common task in ETL (Extract, Transform, Load) projects. Constantly the users/customers may raise format request regarding the Excel extract. To g...

View detail

Create ETL Project for Collecting Sales Data using SSIS

1192 views   0 comments last modified about 4 years ago

Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared fold...

View detail