Forum Discussion

slaytanic70's avatar
slaytanic70
New Contributor III
8 years ago

Script snap to call windows exe

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?

script

3 Replies

  • mina's avatar
    mina
    Employee
    8 years ago

    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.

    • slaytanic70's avatar
      slaytanic70
      New Contributor III
      8 years ago

      @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's avatar
      slaytanic70
      New Contributor III
      8 years ago

      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