如何遍历多个文件并使用 SSIS 包处理它们? [英] How can I loop through multiple files and process them using SSIS package?

问题描述

我们有这样一种情况，即我们使用相同的 SSIS 包导入具有相同格式的多个文件.正在从 .net 程序集加载和执行包.目前正在为每个文件重新加载包.

We have a situation where we are importing a number of files with the same format, using the same SSIS package. The package is being loaded and executed from a .net assembly. Currently the package is being reloaded for each file.

我想在.net进程的初始化过程中加载一次包，然后为每个文件执行它，以节省为每个文件重新加载包的开销.这是一个安全的流程吗?

I would like to load the package once during the initialisation of the .net process, and then execute it for each file, to save the overhead of re-loading the package for each file. Is this a safe process to follow?

推荐答案

这对我来说似乎是安全的.但是我会对该过程进行一些受控测试，也许首先使用一个非常简单的 SSIS 包，然后再使用更复杂的包.

It seems like it would be safe to me. But I would run some controlled tests on the process, perhaps with a very simple SSIS package first, then your more complex one.

我不能说我自己已经完成了这个场景.

I can't say that I have done this exact scenario myself.

这篇关于如何遍历多个文件并使用 SSIS 包处理它们?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！