Home Dashboard Directory Help
Search

SSIS Execute SQL Task SQLStatement is changed upon copy/paste by Aleksandr Krymskiy


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 785052
Opened: 4/18/2013 12:22:15 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Hello,

When copying and pasting an "Execute SQL Task" where SQLStatement is a query formatted with tab characters, the resultant copy has all tab characters replaced with space characters.
Details
Sign in to post a comment.
Posted by Microsoft on 4/8/2014 at 11:39 PM
Hello
Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SSIS. The reasons for closing these bugs are following:
1.     The fix is risky to implement in the current version of the product
2.     Scenarios reported in the bug are not common enough
3.     A viable workaround is available.

If the issue is a critical business interruption, please call CSS (Customer Support Services).

Thanks again for reporting the product issue and continued support in improving our product.

Mariusz Cichomski
Program Manager
Microsoft
Posted by Microsoft on 5/23/2013 at 1:27 PM
Hello Aleksandr. We’ve looked into this item. While it will not be addressed in the current release cycle, we have added it to a list for consideration for the next. Thank you for the feedback. We will keep track of the suggestion. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Aleksandr Krymskiy on 4/18/2013 at 12:25 PM
Tabs are not preserved on the connect form submission either. I attached two screenshots illustrating the problem.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
SQLStatement after copy.png 4/18/2013 8 KB
Original SQLStatement.png 4/18/2013 7 KB