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

Henry Chan 1 Reputation point
2020-12-02T14:27:05.46+00:00

Hi,

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,604 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 24,946 Reputation points
    2020-12-07T17:33:42.33+00:00

    Please provide a fully qualified path to those directories.

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

    UPDATE
    (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
  2. Monalv-MSFT 5,891 Reputation points
    2020-12-03T06:26:21.383+00:00

    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,
    Mona

    ----------

    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
    2020-12-07T17:16:56.803+00:00

    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.
    45814-image.png

    0 comments
  4. Henry Chan 1 Reputation point
    2020-12-07T17:38:21.96+00:00

    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.