SSIS如何在参数中传递变量 [英] SSIS how to pass a variable in a parameter

问题描述

我创建了一个包 SSIS 来拥有一个文件的属性(文件的大小，文件的创建日期).在输入中是我想要拥有该属性的文件的名称，在输出中是文件的属性.为此，我在 vb 中创建了一个脚本任务.文件属性存储在变量中.我想部署包.我的目标是我可以像

I created a package SSIS to have a property of a file (size of the file,date of creation of the file).In the input is the name of the file that I want to have the property and in the output is the property of the file.To do this I created a script task in vb. The file property is stored in a variables.I want to deploy the package.My goal is I can execute the package like

exec dbo.PackageXXX XXX,@Param_size 输出，@Param_date_creation 输出；

exec dbo.PackageXXX XXX,@Param_size output,@Param_date_creation output;

如何将变量的值传递给 SSIS 的参数输出?当我运行包时，我需要做什么来收集输出中的文件结果?

How I can pass the value of a variables to the parameter output of the SSIS? What I need to do collect the file result in out put when I run the package?

推荐答案

您无法在包执行命令中执行任何操作来填充输出变量.执行此操作的常用SSIS 方式"是让包将结果写入历史记录表，您可以在方便时阅读该表.

There is nothing you can do in the package execution command to populate output variables. The usual "SSIS way" of doing this is to have the package write the results to a history table, which you can read at your convenience.

这篇关于SSIS如何在参数中传递变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！