SSIS: Control Flow Tasks

Control Flow Tasks:
1. Execute SQL Task:

2. Bulk Insert Task:
This task is used to copy the large volume of data from flat file to SQL Server destination. This task can load data into a table by using the BULK INSERT SQL command.
The Bulk Insert task supports only OLE DB connections for the destination database.
The Bulk Insert task can transfer data only from a text file into a SQL Server table or view

3. Execute Package Task:

4. Execute Process Task:

5. File System Task:

6. Script Task:

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.