Script snap to call windows exe

[slaytanic70]

Does anyone have a working example that they can share of using a script snap to call a windows executable where the snaplex is located?

[mina]

Hi @slaytanic70, there is an example script in this post
CLI for BCP (SQL SVR) and dynamic file names

CLI for BCP (SQL SVR) and dynamic file names Designing Pipelines

The scenario I needed to accomplish was to pull data from SQL server, group the data sets together based on different fields and then dynamically define the file name based on those groupings. Performance was the #1 consideration and competitive tool sets were able to complete the action in under 2 hours with a 300M record set. For my testing and documentation below, I’m using a local data set of 3.6M records. Initial attempts at using the SQL Read and SQL Execute snaps quickly excluded those…

Let us know how it works for you and any questions.

[slaytanic70]

@mina, thanks so much for this! I’m going to work on it this afternoon and this weekend. I took a quick peek and I think this will do the trick.

[slaytanic70]

I made a simple modification to the 1_Run_BCP_CLI and I replaced the batch file with notepad.exe. I just want to see notepad open.

A couple issues happened:

1. With the snaplex on sqlserver 2012 - nothing happens…it just hangs there.
2. I installed the snaplex on my laptop and had the pipeline run against there. It opens notepad.exe no problem, but the pipeline continues running.

What needs to be done for it to complete?

Thanks for your help!
FS