The SSIS package represents tool for the ETL (Extract-Transform-Load) processing, and it can be used not just to import the data into the database, but to transform, filter, group the data and many other tasks.
This article will give explanation how to import the simple Excel worksheet into the SQL database Before creating an SSIS package, the user needs to create new project in BIDS by choosing the Integration Services from the Business Intelligence list from the left, navigate to the Integration Services project , and define name for the project like shown in the image below To be able to import the data from the Excel worksheet into the SQL database, the user first needs to define the Data Flow Task, dragging from the SSIS Toolbox into the Control Flow area like shown in the image below Double-clicking the Data Flow Task will open the Data Flow tab.
That could be done from the Mappings tab like shown in the image below Not all the columns from the source need to be imported.
During winter, he likes skiing the most, but all other snow activities, too.
If the data is inserted or overwritten with new ones, importing process will be successfully accomplished, and the data will be added to the table in SQL database For SSIS package documentation, consider Apex SQL Doc, a tool that enables documenting SSIS packages from file system, SSIS package store, SQL Server, SSISDB catalog and SSIS project file in different output formats, and with various included details.
To compare SSIS packages with each other, consider Apex SQL Diff.
However, importing the data this way narrows the process and won’t allow user to execute more complex tasks with different kind of the data, and multiple files.
The SSIS packages offer solution for this kind of problem.Connection with the destination, in this case SQL Server database, can be established through the OLE DB connection, choosing it from the list in the New Connection Manager window.