SSIS: Cut and pasting tasks
Anyone that has used SQL Server Integration Services (SSIS) and tried to cut and paste tasks from different parts of the control flow will appreciate this tip.
SSIS has the concept of containers that allows tasks to be grouped, in a loop or in a sequence. If you try and past a task into one of these containers some wonderful thnig happen. Generally the task is pasted in a bizarre location resulting in your container having its size and shape changed. The task can be moved and the container resized, however if you have more than one layer of containers, i.e. a sequence inside a loop inside another loop, then reszing all the containers is a bit of a pain.
The trick to avoid this,
- paste your task onto the main flow area, not in a container,
- change the name
- drag the task into the container.
(The changing of the name is really only required if you want to paste the task in the same container as the original.