Database Management

Task Factory Expression Based Components Require Read/Write Access to C:\Windows\TEMP

First published date

7/29/2021 10:19 PM

Last published date

1/30/2025 4:11 PM

Overview

Task Factory’s expression based components require read and write access to the C:\Windows\TEMP directory. This directory is used to store temporary code during package executions. If read or write access is denied to this directory, an error message similar to the following may be encountered:

1.jpg
 

Product section

Task Factory (TF)

Resolution

To resolve this issue, the profile executing the SSIS package must be granted read and write access to the C:\Windows\TEMP directory. Components which may be affected this behavior include:
  • Control Flow Components
  • Expression Task
 
  • Data Flow Components
    • Advanced Aggregator Transform
    • Advanced Conditional Split Transform
    • Advanced Derived Column Transform
    • Advanced Lookup Cache Transform
    • Advanced Lookup Transform
    • Case Transform
    • Data Cleansing Transform
    • Filter Rows Transform
    • Null Handler Transform
    • RegEx Replace Transform
    • Replace Unwanted Characters Transform
    • Trim Plus Transform