The Java Database Connectivity (JDBC) Insert Task gives you the ability to perform a SQL insert into a JDBC-compliant database.
In addition to specifying the database tables and columns where data are placed, the JDBC Insert Task provides advanced features, which make it extremely flexible. The advanced features should be used if your solution is complex and you need to be able to map out inter-table relationships, or if the nature of your solution necessitates the execution of a SQL statement prior to the insertion of data (for example, when a number is acquired from a sequence generator).
This task has a wizard-like Properties tab with multiple steps.