Table of Contents
Introduction
What is SSIS package?
Features
SSIS Import/Export Wizard
Creating or maintaining SSIS packages
Features of the data flow task
How to create a simple SSIS package
References
Conclusion
History
Introduction
SQL Server Integration Services (SSIS) is an excellent component with some great features of Microsoft SQL Server 2005 & 2008 edition as well. Today’s business are completely depends on the data which are comes thru user / customers. Business analyst analysis the data to figure out the market. So not only in business sector but also with the other areas; data are very much important.
So, if we think for a small single domain business, it could be easy to collect the business transactional data by using any data migration tools. But if it’s in a large domain or even multiple domains then how you centralized all the data’s; data centralization is very common and essential requirement for the business people’s where business become globalizing day by day.
In this article, we will discuss about Microsoft SSIS package, how to create SSIS package for smooth data migration, design SSIS package for single domain, design SSIS package for multiple domains and some other features i.e., SSIS Import/Export etc.
What is SSIS Package?
By definition, SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software which can be used to perform a broad range of data migration tasks.
SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
Features
SQL Server Integration Services (SSIS) has various useful features, for example SSIS import/export wizard, creating / maintaining SSIS package using Microsoft visual development IDE /tools etc. Let’s try to understand few more on the above features:
SSIS Import/Export Wizard:
This wizard helps you to create SSIS package very quickly. For example we want to move data from a single data source to another destination, note that we can do this without transformations and wizard almost seems to Microsoft SQL Server Import / Export wizard.
Creating or maintaining SSIS packages:
SQL Server Business Intelligence Development Studio (BIDS). allow users to create / edit SSIS packages using a drag-and-drop user interface.. BIDS is very user friendly and allow you to drag-and-drop functionalities. Variety of elements that define a workflow in a single package. Upon package execution, the tool provides color-coded, real-time monitoring.
Read more: Codeproject