Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1847
  • Last Modified:

Read output of exe in SSIS Package

Hi,

I am executing a exe in SSIS using Execute Process Task. This exe returns a integer value. How to capture it in SSIS package?
0
priyanka_kothari
Asked:
priyanka_kothari
2 Solutions
 
lcohanDatabase AnalystCommented:
You can call a SSIS from within a SSIS and pass a parameter like:

DTSRun /S "(local)" /N "PkgTest" /A "varFile":"8"="File_001.xls" /E

Note: "8" is DataType ID

Parameterized SSIS Package - Passing parameters to SSIS package from command line
DTSExec /SQL "\PkgTest" /SERVER "(local)" /SET "\Package.Variables[User::varFile].Value";"File_001.xls"

Please refer the following to get more info on DTExec:

http://msdn.microsoft.com/en-us/library/ms162810.aspx

0
 
Michael-ThomasCommented:
In the Process section of the Execute Process task there is a spot to supply a variable for the standard input/output which you can use later in your package
0
 
Rajesh_mjCommented:
Please create a variable and use the variable in the ExecValueVariable property of the Execute Process Task.

Please refer below link for the details:
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/8df1c8e0-5149-44bd-a6cd-0c7f1364a7cc

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now