Active Oldest Votes. I answered this in this other question : You should invoke the sqlcmd command-line tool from your batch file. Improve this answer. Community Bot 1 1 1 silver badge. Tahbaza Tahbaza 9, 2 2 gold badges 24 24 silver badges 39 39 bronze badges.
Shessuky Shessuky 1, 17 17 silver badges 22 22 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Returning no output D. Using return status E. Writing variable contents to a file F. Capturing the result of a command to a file.
Search for:. In this article we will: Determine the path to the desired version of DTExec. Determine the path to the desired version of DTExec. In case you are wondering, passwords are stored in the SSIS package file in encrypted form. Execute the package from a batch file Paste the following SQL code Make sure you have the extension '.
Double-click the new batch file to execute it. Click the OK button. Short answer: No. Batch files by themselves can't do this. What kind of database server are you using?
Oracle, mySql, Sybase, Microsoft, Terradata,??? For example, with a Sybase database, you can use the isql commandline client to run from a batch file: isql -S server -D database -U user -P password -i script. Bevan Bevan Thuglife Thuglife 2 2 silver badges 3 3 bronze badges.
Diomidis Spinellis Diomidis Spinellis 18k 5 5 gold badges 56 56 silver badges 79 79 bronze badges. Andy Joiner Andy Joiner 5, 3 3 gold badges 40 40 silver badges 67 67 bronze badges. MAKE, Veh. ECHO sqlcmd. ECHO Report is done. Hit any key to close this window Viewed 26k times. Vishal Vishal Add a comment. Active Oldest Votes. I answered this in this other question : You should invoke the sqlcmd command-line tool from your batch file. Community Bot 1 1 1 silver badge.
Tahbaza Tahbaza 9, 2 2 gold badges 24 24 silver badges 39 39 bronze badges. Shessuky Shessuky 1, 17 17 silver badges 22 22 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.
0コメント