Learn MS SQL with Free Lessons & Tips

SSIS is a platform for data integration and workflow applications. It features a 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.

• Control Flow Elements: These are different tasks that define the flow of execution in an SSIS package. ...
• Data Flow Elements: These are the components that provide functionality to move and transform data. ...
• Event Handlers: These are special tasks that run in response to run-time events.

Create Foreign Keys on transactional table and reference with Primary key table which you are taking reference. Ex.  Tblemployee - empId, empname, deptid Tbldepartment - deptid, deptname Create FK on tblemployee table on deptid column and make reference to the tbldepartment table with deptid column to maintain the integrity 

In SSMS, in Object Explorer, select the SSISDB database, select a folder, select a project, and then select a package. Right-click on the package and select Schedule. The New Schedule dialog box opens. On the General page of the New Schedule dialog box, provide a name and description for the new scheduled job.

The SSIS Import/Export Wizard lets the user create packages that move data from a single data source to a destination with no transformations. The Wizard can quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.