<SQL Service Acct>\AppData\Local\Temp\Vsta folder filling

Henry Chan 1 Reputation point


We have an issue with <SQL Service Acct>\AppData\Local\Temp\Vsta folder filling and not getting cleaned up. New folders within Vsta are getting created and the contents of these folders are .dll and .nlp files. From what we can tell, this appears to be script task related.

What's the correct way to maintain this folder. It's old that the VSTA is getting filled and not being cleaned up.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,079 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,321 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,011 Reputation points

    Please provide a fully qualified path to those directories.

    In the meantime, check it out here: clear-recent-projects-list-in-visual-studio-2015

    (1) Please check the following post: set-blobtempstoragepath-and-buffertempstoragepath-to-fast-drives

    And try to modify those setting to see if you can set both BLOBTempStoragePath and BufferTempStoragePath point to a different file system location.

    It seems that adding more RAM to the SSIS server would be helpful. It will prevent swapping from memory to a file system.

    (2) .nlp temporary files are created by the .Net Framework 3.5. When you will upgrade your SSIS packages from 2008 to 2019, Script Task will use .Net Framework 4.* Thar version of the framework doesn't create such temporary files.

    1 person found this answer helpful.
    0 comments No comments

  2. Monalv-MSFT 5,881 Reputation points

    Hi @Henry Chan ,

    Could you please share the screenshot of the example folder in Script Task?

    Locating the Assemblies
    In SQL Server 2019 (15.x), the Integration Services assemblies were upgraded to .NET 4.0. There is a separate global assembly cache for .NET 4, located in <drive>:\Windows\Microsoft.NET\assembly. You can find all of the Integration Services assemblies under this path, usually in the GAC_MSIL folder.

    Please refer to Upgrade Integration Services Packages.

    Best Regards,


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?

  3. Henry Chan 1 Reputation point

    Hi @Monalv-MSFT ! We are on SQL 2019 and Visual Studio 2008 (SSIS packages have not been updated yet).

    Here is an example of folders that I see getting created and not cleaned up.

    0 comments No comments

  4. Henry Chan 1 Reputation point

    Hi @Yitzhak Khabinsky ,

    The full path is C:\Users\<SQL Service Acct>\AppData\Local\Temp\Vsta. These files/folders are being generated on the SQL Server where tasks are being run.