Container Tasks in SQL Server 2008 Integration Services

The File System Task Editor should be configured with the below details:

Destination Connection

IsDestinationPathVariable

False

DestinationConnection

SystemDatabaseBackups

OverwriteDestination

True

General

Name

File System Task

Description

File System Task

Operation

Operation

Move file (Choose this Option from the Drop-down list)

Source Connection

IsSourcePathVariable

True

SourceVariable

User:DatabaseBackupFiles (Choose the user variable)

8.       Finally, to execute the package, right click the ForeachFileEnumerator.dtsx package from the solution explorer and select Execute Package option from the drop down list. Once the package has successfully executed you will be able to see the below screen.

Task Host Container

 The Task Host Container is a default container within which a single task fits in. When you are designing an SSIS package if you haven’t specified a container for a single task then SSIS places it within a Task Host Container.


Sequence Container

 SSIS Developers can leverage Sequence Containers when they need to divide the entire package into multiple separate control flows depending on the kind of work each container has to do. There are several advantages of using Sequence Containers within SSIS packages :

a.       You can use sequence container to group tasks so that if you don’t need then, you can just go ahead and disable them instead of deleting them from the package.

b.       Sequence Containers help to manage the properties of multiple tasks present within the Sequence Container in one step. This can be done by modifying the properties of a single container rather than changing them one by one .

c.        You can create an event handler for a single container rather than creating one for each task.

d.       By using Sequence Containers you can effectively handle transactions for a set of tasks.

In the below snippet we have added a Sequence Container, and within the sequence container we are executing the Foreach file enumerator example.



Conclusion

In this article you have seen how to use the different types of container tasks such as For Loop Container, Foreach Loop Container, Task Host and Sequence Container.

Pages: 1 2 3




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |