x

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, 2011 at 08:43 AM in Default

Raj More gravatar image

Raj More
1.7k 78 82 84

If there is, I've never found it. I agree, though, it is a right royal PITA.
Feb 23, 2011 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, 2011 at 10:43 AM

Raj More gravatar image

Raj More
1.7k 78 82 84

Good find Raj. I am sure others reading this will find your solution useful. Thanks for coming back and updating us.
Apr 26, 2011 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, 2011 at 12:38 AM

Fatherjack gravatar image

Fatherjack ♦♦
42.3k 75 78 108

(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, 2011 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x927
x581

asked: Feb 23, 2011 at 08:43 AM

Seen: 1240 times

Last Updated: Feb 23, 2011 at 08:43 AM