A SSIS Package is an organized collection of data connections, control flow elements, data flow tasks, events handlers and variables created by a Business Intelligence Development Studio (BIDS) or Programmatically to achieve an organizational goal to collect clean data. Refer below image for a SSIS Package.
For more detail explanation assume below scenario:
You have a database table named table_2 which refresh daily from database table_1 below are the steps which you perform daily manually.
â€‹You perform all the above steps manually. Alternative you can create a SSIS Package contains all the above steps and execute a single package daily. I think the alternative method is very good. So this is a practical scenario of SSIS Package. This example also explain the Question "Why to use SSIS Package?".
Finally how to create a SSIS Package?
You can use BIDS or Import and Export Wizard to create a SSIS Package. For step by step guide refer this link.
Please login to post your valuable comments.
Get the latest vLemonn news first