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?
Hi @slaytanic70, there is an example script in this post
CLI for BCP (SQL SVR) and dynamic file names
Let us know how it works for you and any questions.
@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.
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:
- With the snaplex on sqlserver 2012 - nothing happens…it just hangs there.
- 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!