SSIS File System task cannot use variable to configure destination path

SSIS File System task cannot use variable to configure destination path Demand:

In SSIS2012, a package that imports data from a flat file requires you to copy the file that handles the error to a dedicated folder for administrators to view.

Problem Description:

1. Add a parameter to the package parameter to the target folder path.

2. Add a file system task to copy the error file to the specified folder. The task executes when the file processing fails.

3. Because it is processed in a loop, the file name is different each time it is processed, so both the source and destination files are configured using variables.

4. When configuring the target path, first select the target path to use the variable, found in the target Path variable drop-down box cannot select the variable, also cannot enter the variable name. Source file variables can be selected and entered.

Problem Recurrence:

1. Create a new package, add a parameter that represents the destination folder path, and add a variable that represents the source file name.

2. Add a file system task.

3. Select the target path using the variable, in the target Path variable drop-down box you can select a variable, or you can enter a variable name. The problem cannot be reproduced.

4. Reopen the problematic package, repeat step 2-3, the problem exists.

Problem solving:

1. After querying the MSDN documentation, it was found that there was no mention of this.

2. Using Google queries, we found that there are similar cases. The reason is that there is a parameter that is the password that ticked the sensitive content.

3. Remove this tick, save the password in clear text, re-add the file system variables, and find the target path can use the variable. Problem solving.

4. The initial estimate is a bug in SSIS.

SSIS File System task cannot use variable to configure destination path