Matt Fraser

My feedback

  1. 86 votes
    Sign in
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    29 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 47

    <=-=Jun 26 2017 1:02AM=-=>

    I have had the exact same issue, intermittently whenever I open script tasks all my code seems to have vanished and all the “ReadOnlyVaraiables” and “ReadWriteVariables” have also disappeared. It happens for c# and VB script tasks. This is is extremely frustrating and is impossible to develop a project when code randomly keeps disappearing. I’m wondering if this is a bug with Visual Studio 14.0.23107.0 D14REL. Can anyone at Microsoft shed some light on this please?

    <=-=Jun 29 2017 10:45PM=-=>

    Got the same problem. Seems like the Script Task is cleared when the project/Visual Studio i closed/shut down.

    <=-=Jul 18 2017 5:38PM=-=>

    Same problem for me, too. Once the original code in Script Task was still present after reloading the solution. But after that they are gone, along with ReadOnly/ReadWriteVariables and ConnectionManagers. I’m using SSDT 14.0.61705.170 (which just came out) with VS 14.0.25431.01 update…

    An error occurred while saving the comment
    Matt Fraser commented  · 
    Matt Fraser supported this idea  · 
    An error occurred while saving the comment
    Matt Fraser commented  · 

    I am also having the same issue with SSDT 2017 (15.6.2). Target server version for the project is SQL Server 2016. The only extension beyond SSDT that we have installed is BI Developer Extensions 2017 2.1.1.

    I'm hesitant to upgrade to the latest SSDT release because my installation has proven fragile before and broke the last time we tried to upgrade.

    Note that all of the scripts that disappeared were in a For Each Loop container. There are two other scripts that we had in this package, one in a parent Sequence container and the other in the OnError Event Handler, and neither were affected.

    Some of the scripts affected were very basic, only setting the value of a read/write variable.

Feedback and Knowledge Base