Anonymous

My feedback

  1. 82 votes
    Sign in
    (thinking…)
    Sign in with: Microsoft
    Signed in as (Sign out)

    We’ll send you updates on this idea

    27 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…

    Anonymous commented  · 

    same issue here, vs 2017 Enterprise
    Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT)
    Version 15.8.1
    VisualStudio.15.Release/15.8.1+28010.2003
    Microsoft .NET Framework
    Version 4.7.02558

    Installed Version: IDE Standard

    Microsoft Visual Studio Tools for Applications 2017 00371-40000-00001-AA167
    Microsoft Visual Studio Tools for Applications 2017

    C# Tools 2.9.0-beta8-63208-01
    C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

    Common Azure Tools 1.10
    Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

    GitLab Extension for Visual Studio 1.0.0.129
    A Visual Studio Extension that brings the GitLab Flow into Visual Studio.

    NuGet Package Manager 4.6.0
    NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

    Project 1.0
    Information about my package

    ProjectServicesPackage Extension 1.0
    ProjectServicesPackage Visual Studio Extension Detailed Info

    ResourcePackage Extension 1.0
    ResourcePackage Visual Studio Extension Detailed Info

    ResourcePackage Extension 1.0
    ResourcePackage Visual Studio Extension Detailed Info

    SQL Server Analysis Services 14.0.1016.285
    Microsoft SQL Server Analysis Services Designer
    Version 14.0.1016.285

    SQL Server Data Tools 15.1.61808.07020
    Microsoft SQL Server Data Tools

    SQL Server Integration Services
    Microsoft SQL Server Integration Services Designer
    Version 14.0.3002.107

    SQL Server Reporting Services 14.0.1016.285
    Microsoft SQL Server Reporting Services Designers
    Version 14.0.1016.285

    SsmsVsIntegration 1.0
    Information about my package

    Visual Basic Tools 2.9.0-beta8-63208-01
    Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

    Visual Studio Code Debug Adapter Host Package 1.0
    Interop layer for hosting Visual Studio Code debug adapters in Visual Studio

    Data Flow Task containing
    XML Source going to Script Component (code does not save, lost a full days work) Any code written was auto deleted from the temp directories.

Feedback and Knowledge Base