SSIS - Creating a New package using Aggregate function

SSIS (Sql Server Integration Service): Here we can see about how to Create a package and to execute and manage it. This article explains the basic steps of creating a ssis package using an oledb source and oledb destination in which we get an aggregate result in destination using aggregate function in between them. Find how to create a New package using Aggregate function.

Learn Creating a New package using Aggregate function

SSIS [Sql Server Integration Service]

It is used for building high performance data, which include extraction, transfermation, and Load(ETL) for date warehousing. It is used for automating Sql Server.ETL is a task of Importing to or Exporting from a database.

We can access data using ssis for

  • Microsoft Access Database

  • Microsoft Excel Worksheet

  • Sqlserver Database

  • OLE Db Providers and

  • Flat Files

  • Export and Import

    You can use Import and Export in Sql server by using the following steps.

  • Open Sql Server Management Studio and

  • Right Click your database name and click task

  • In task click Export or Import option

  • You will get an sql server import and export wizard

  • Click next and choose your data source and click next

  • click destination server and give your input server details and click next

  • Select copy data from one or more tables or views and click next

  • select your table from table list and click next

  • Click Run immediate option for normal transaction and click next

  • Click finish

  • Expand the table nodes to verify that the created table is in your table list.

    SSIS Steps to Export or Import

    Now we are going to implement the same using SSIS package which we can execute when ever we need this steps to be done.

    This article explains the basic steps of creating a package and managing and executing package.
  • Open SQL Server Business Intelligence Management Studio

  • Create a package.dtsx

  • 1

  • opening the SSIS project

  • 2

    After opening the SSIS project drag and drop a data flow task from control flow and double click the dataflow task


    After opening the data flow task from control flow and double click the Ole db Source from data flow sources.


    Double click the Ole db Source or click edit to select the data source and give source server and database and tables.



    click on the column tab for selecting fields for table.


    Drag and drop the Aggregate function.


    Select the fields and aggregate fields it may be sum, count,etc.


    Select OleDB destination from data flow destinations and drop it after aggregate function.


    Select OleDB destination database and create destination table.


    After that do mappings for the fields.


    Execute the package after doing all these steps and save it.


    Execute the package we get Yellow colour for running process, Green colour for completed process and red colour for error packages.


    Process completed successfully in this final step.


    Execution results can be viewed in execution results.


    These are the steps to be done for using ssis package and to execute the package successfully.


  • Steps to be followed (43047-27052-SSIS-Basics-to-Learn.docx)
  • SSIS steps Images (
  • Comments

    Author: preethi01 Aug 2011 Member Level: Gold   Points : 1

    You Article is very good and useful to me.
    Thank you, Keep on posting your articles
    All the Best For Future

    Author: Bhuvana S02 Aug 2011 Member Level: Gold   Points : 0

    Thanks preethi for your comments.

    Author: Prabu Thangavelu23 Aug 2011 Member Level: Gold   Points : 1

    Hi Bhuvana,

    Nice article. I got some idea about SSIS.

    Need more article from yourside.


    Author: Vidhya15 Nov 2011 Member Level: Gold   Points : 0


    Thanks for posting a good article. Got some idea using aggregate functions in SSIS.


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: