Thursday, May 24, 2018

SSIS - Sequence Container || Subset of the package control flow

In this tutorial, we are going to explain the functionalities of Sequence containers in SQL Server Integration Services. 

Sequence containers group the package into multiple separate control flows, each containing one or more tasks and containers that run within the overall package control flow. The Sequence container can include multiple tasks in addition to other containers.  There are many benefits of using a Sequence container:
  • Disabling groups of tasks to focus package debugging on one subset of the package control flow.
  • Managing properties on multiple tasks in one location by setting properties on a Sequence container instead of on the individual tasks.
  • For example, you can set the Disable property of the Sequence container to True to disable all the tasks and containers in the Sequence container.
  • Providing scope for variables that a group of related tasks and containers use.
  • Grouping many tasks so you can more easily managed them by collapsing and expanding the Sequence container.

SSIS – How to import Text or CSV file into SQL Server

There are many easiest ways to import your data from any csv or text file into your database table. If there is a csv or text file which is coming from any other source/server to your server and you need to import this file on daily basis at the scheduled time automatically, and update the changes if changes are in the file. To meet your business requirements, SQL Server Integration Services (SSIS) comes into the picture to import flat files on a scheduled basis.
There are very simple steps to create a package in SSIS and import the data from any csv or text file into your database table. 
Please watch the below video to understand the process –
Unfortunately, SSIS requires static metadata, what I say is it will remember what you set in the Excel Connection Manager or Flat File Connection Manager, so if tomorrow the number of columns is not the same anymore then the package will break at the validation phase.