New Component – Execute Process

Need to execute a batch file?  Visual Basic Script?  EXE?  You are in luck.  Use the new s9502 (Execute Process) stage component to execute any process by generating an SSIS package which includes an “Execute Process Task”.  Provide a path to the executable and input argument/s.  LeapFrogBI will call the executable at the exact point in your data flow that you define in precedence.

 

The below example uses command line arguments to create a new directory.  This is a very simple example, but keep in mind that you can integrate virtually any executable into your data flow using s9502.

 

 

Note that s9502 is available to projects set to deploy to SQL Server 2016 and later versions.  Also, a return code equal to “0” is considered a successful execution.  All other return codes will report a failure.  The process will be executed synchronously with no timeout applied.

 

Enjoy!

What We Do

We provide SMBs with custom data analytics services.

Built to Spec
We design custom solutions.

Low Cost per User
Empower as many report users as you like.

You Own It
Everything from the data solution to reports is yours to keep.

Month-to-Month
No upfront costs and no long-term commitment.

Available 24/7
We monitor and maintain everything 7 days a week.

Support
Unlimited access to a team of data experts.

Find out how 
our clients
are getting

10x ROIwithin 6 months

CLICK HERE

Stay Connected With Us

Join our monthly newsletter to receive LeapFrogBI’s latest insights and articles on automated, customized reporting.

LET’S TALK

Have any questions? Reach out to us, we would be happy to answer.

';