如何将存储过程中的参数传递给SSIS Precendence Constraints [英] How to pass out parameter from stored procedure to SSIS Precendence Constraints

问题描述

我有一个SSIS包，我需要将数据从excel文件上传到sql表，之后我需要根据一些验证将文件移动到另一个文件夹。我需要在数据库级别进行这些验证。对于该验证，我创建了一个存储过程，该存储过程将返回一个输出值。根据该值，我需要将文件移动到特定文件夹中。我使用文件系统任务来移动文件，但是我无法将值传递给优先约束。



例如。如果我的存储过程返回1，我需要将文件移动到已成功文件夹中的失败文件夹。



任何人都可以帮助我实现它。 />


你的帮助真的很明显。



谢谢



删除了不必要的代码块

I have a SSIS Package in which I need to upload the data from an excel file to sql table after that I need to move the file to Some another folder depending upon some validations. These validations i need to do at database level. for that validations i have created a stored procedure and this stored procedure will return a output value. Depending on that value I need to move the file in a specific folder. I have use File System task to move the file, but I am not able to pass the value to the precedence constraint.

for eg. If my stored procedure return 1 I need to move the file to Failed Folder which is already created else to success folder.

Can Anyone help me to achieve it.

Your help would be really appreciable.

Thanks

unnecessary code block removed

推荐答案

请参考文章：

http://www.codeproject.com/script/Articles/ArticleVersion.aspx?waid=141514&aid=820687 [ ^ ]



谢谢，

Baliram Suryawanshi

Hi,

Please refere article available at:
http://www.codeproject.com/script/Articles/ArticleVersion.aspx?waid=141514&aid=820687[^]

Thanks,
Baliram Suryawanshi

这篇关于如何将存储过程中的参数传递给SSIS Precendence Constraints的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！