How to pass out parameter from stored procedure to SSIS Precendence Constraints

Question

0.00/5 (No votes)

See more:

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

Posted 16-Sep-14 2:53am

Piyush Jain618

Updated 16-Sep-14 2:59am

Nelek

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Baliram Suryawanshi · Answer 1 · 2014-09-19T10:39:00

Solution 1

Hi,

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

Thanks,
Baliram Suryawanshi

Posted 19-Sep-14 10:39am

Baliram Suryawanshi

Comments

Thiyagarajan.B 11-Jan-16 14:51pm

Hi,
I need to pass value through Output Parameter and update some values in the table using SSIS Package.

Example: If I pass empty value in Output parameter, than we need to insert new Customer details; If I send with value in the Output parameter, the Customer info have to get updated.

Issue: Whenever I pass value to output parameter, NULL values goes to the SP

Any help appreciated.