在SSIS中使用Temp文件夹 [英] Using Temp folder in SSIS

问题描述

大家好，

我想知道是否可以在SSIS中使用临时目录。 

I was wondering if it is possible to use a temp directory in SSIS. 

我有一个SSIS包，使用数据流任务将数据从SQL表加载到一个平面文件，然后我有一个后续任务，使用FTP任务从文件夹中选择该文件到FTP位置。

I have an SSIS package that loads data from SQL table to a flat file using Data flow task, and then I have a subsequent task that picks this file from a folder to an FTP location using the FTP task.

但是，我希望数据流任务将平面文件放在临时文件夹中并且  FTP任务从'临时文件夹'中挑选文件，该文件将在所有控制流程任务完成后删除。

However, I want the Data Flow Task to drop the flat file in a temp folder and  the FTP task to pick the file from the 'temp folder' which will be deleted after all the control flow tasks has been completed.

我想使用临时文件夹的原因是因为控制流任务运行的其他进程可能会执行一段时间，并且由于正在处理的数据的敏感性，我不想让任何用户有机会获得
访问该文件而另一个用户流程仍在运行。

The reason why i want to use a temp folder is because there are other processes that the control flow task runs which might task some time and because of the sensitive of the data that is being process, I dont want to give any user the opportunity to have access to the file while the other processes are still running.

谢谢

me

推荐答案

您好lilutchay，

Hi lilutchay,

根据您的问题，我们可以使用
文件系统任务删除FTP任务后的临时文件夹。

According to your issue, we could use File System Task to delete the temp folder after FTP task.

操作：删除目录

最好的问候，

Mona Lv

这篇关于在SSIS中使用Temp文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！