SSIS - How To Execute Batch File By Using SSIS Package

Scenario:

We have created a batch file that copies all the files from Source folder to Destination folder. We want to execute this batch file in SQL Server Integration Services (SSIS) Package.

Solution:

To execute batch file from SQL Server Integration Services Package, we will be using Execute Process Task from Control Flow Items.

 Step 1: 
Drag Execute Process Task to Control Flow Pane. Double click or Edit it by right click
Locate the path for your Executable, In my case the CMD.exe is present on C:\Windows\System32\cmd.exe.
In Argument , provide the path of your batch file as given below
/c C:\Users\ashahzad\Desktop\Mybatch.bat

Note:
 You can create variables to save paths for Executable and Arguments so on different machines you can change those values by using SSIS Configuration.

Final Step: 
After executing our SSIS Package, we can see that the batch file was executed successfully by SSIS Package and files were copiedd from Source to Destination Folder.


8 comments:

  1. seostar2May 11, 2020 at 11:00 AM

    The first thing to look at when trying to decide if a new copy machine is right for your business is, well, your business. photostat machine

    ReplyDelete
  2. awaisJanuary 4, 2021 at 10:42 PM

    Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. Vacuum casting parts

    ReplyDelete
  3. carshippingMay 28, 2021 at 10:59 AM

    There is such a great amount in this article I would never have considered all alone. Your substance gives perusers things to consider in an intriguing way. Much obliged to you for your unmistakable data.estrella black

    ReplyDelete
  4. logan pualJune 17, 2021 at 7:38 AM

    Advances in interchanges and innovation have carried with it an off-shoot marvel that has significantly affected the manner in which people and organizations interface and manage one another. pe file

    ReplyDelete
  5. meme128playAugust 15, 2021 at 3:27 AM

    There are particular dissertation website pages on the web guides have got seemingly uncovered inside the web-site. Battery Safety Test Chamber

    ReplyDelete
  6. AdamNovember 11, 2021 at 4:56 AM

    The item will give you a keyword rich link a great useful website page Very interesting information, worth recommending. However, I recommend thisvintage clothing uk

    ReplyDelete
  7. Sinen YokuDecember 28, 2021 at 10:45 PM

    Thanks for the cool informative post. Keep up the great work :)
    Transfer large files

    ReplyDelete
  8. Cho co March 28, 2022 at 6:00 AM

    If the toner runs out, it is up to the rental company to replace it, which means less expense for the renter. renting impresoras alicante

    ReplyDelete

Subscribe to: Post Comments (Atom)