What are all the RDBMS Tasks

What are all the RDBMS Tasks?

• Execute SQL Task
• Bulk Insert Task

Execute SQL Task: 

This is used to execute the SQL Statements like, Sql Scripts Stored Procedures and           DDL,DML,DCL against RDBMS tasks.

• DDL(Data Definition Language) - CREATE, ALTER, DROP
• DML(Data Definition Language) - SELECT, UPDATE, INSERT, DELETE
• DCL(Data Controlling Language)-GRANT, REVOKE

Bulk Insert Tasks:

This is used to extract the data from only Flat Files to Sql Server with out any transformations. It gives high performance when comparing with other tasks.