Control Flow Tasks:
1. Execute SQL Task:
2. Bulk Insert Task:
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:
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.