Home Dashboard Directory Help
Search

Copying and Pasting Script Components can cause incorrect code to execute by buddylee17


Status: 

Resolved
 as Fixed Help for as Fixed


1
0
Sign in
to vote
Type: Bug
ID: 840894
Opened: 3/25/2014 7:36:46 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

I'm guessing this is related to the fact that the project is not renamed.

When copying and pasting Script Component A to Script Component B, they both are assigned the same project name. Assuming both Script Components remain in the same package and Script Component B has been altered, the compiled code for Script Component A gets executed and Script Component B does not. I've attached an example so I'd assume "could not reproduce" is not acceptable.

When there are multiple output buffers with several output columns per buffer, the ability to copy/paste components (without undesirable side effects) would be an extreme productivity booster.

This bug has sucked a significant amount of valuable developer hours from my team. Apparently, Script Tasks are also susceptible to this bug. I'm very surprised at the fact that the bug has been known for over 9 years: http://consultingblogs.emc.com/jamiethomson/archive/2005/01/13/SSIS_3A00_-Beware-of-copying-and-pasting-script-tasks.aspx

Hopefully, this can be resolved in the near future.

***Also, the file extension ".dtsx" needs to be added to the allowed file attachment list. I had to add ".txt" to upload the packages.***
Details
Sign in to post a comment.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
Not Copy Paste Task.dtsx.txt 3/25/2014 180 KB
Copy Paste Task.dtsx.txt 3/25/2014 180 KB