question

Raj More avatar image
Raj More asked

Copy Paste woes

I am transferring objects between two SSIS packages using Copy-Paste. When I paste the objects, they are put wayyyyy far out right and to the bottom and I have to spend time moving them back to where they should be. If I paste in a For-Each or Sequence container, the container gets stretched out right and bottom. Is there a way for me to avoid this pain and have SSIS paste where I want it to go?
ssissql-server-2008-r2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
If there is, I've never found it. I agree, though, it is a right royal PITA.
3 Likes 3 ·
Raj More avatar image
Raj More answered
I found it!! If you copy paste the first time, they go to the far bottom-right. Just click somewhere on the control flow other than those objects, then select them and copy-paste them again. Now they are pasted very close to the original control objects.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
Good find Raj. I am sure others reading this will find your solution useful. Thanks for coming back and updating us.
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
I cant test this in 2008 but my 2005 doesnt do this. I copy items from a data flow in package1 and paste into package2 without great issues. They are not aligned the same but they are not out of view. I can use Ctrl + A to select them all and then choose Format | Auto Layout and align them is necessary.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Andy Leonard avatar image
Andy Leonard answered
I've seen this same behavior in SSIS 2005 and 2008. I believe they've fixed it in Denali - paste works better in the CTP. Andy
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.