x
login about faq Site discussion (meta-askssc)

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?

more ▼

asked Feb 23 '11 at 08:43 AM in Default

Raj More gravatar image

Raj More
1.7k 74 78 82

If there is, I've never found it. I agree, though, it is a right royal PITA.

Feb 23 '11 at 09:02 AM ThomasRushton ♦
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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.

more ▼

answered Apr 25 '11 at 10:43 AM

Raj More gravatar image

Raj More
1.7k 74 78 82

Good find Raj. I am sure others reading this will find your solution useful. Thanks for coming back and updating us.

Apr 26 '11 at 03:42 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

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.

more ▼

answered Feb 24 '11 at 12:38 AM

Fatherjack gravatar image

Fatherjack ♦♦
38.8k 55 69 104

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Feb 25 '11 at 02:41 AM

Andy Leonard gravatar image

Andy Leonard
332 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x749
x392

asked: Feb 23 '11 at 08:43 AM

Seen: 769 times

Last Updated: Feb 23 '11 at 08:43 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.