SSIS- Interview Questions

Q: What is SSIS? How it is related with SQL Server. SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server. This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction,...

Continue Reading →

SSIS - A Basic Demo

Creating SSIS project and getting started So let’s understand the very first requirement of the project. Goal of this demo is understanding SSIS project basics. In this Demo we are going to learn, how we can Upload data from a txt file to Sql server database. We have Customer.txt file...

Continue Reading →

MSBI (SSIS)

What is Data Warehouse? In a very simple word it means, “It's a place where we store all of our data”. How it is different from Database? Usually data warehouse is also a database. The records from multiple data sources (may be some other databases)are collected and stored in Denormalized manner....

Continue Reading →