How to automate Application Deploy with SSIS package
Following is step by step procedure to create and run an SSIS package to Deploy an application.
- Create a new Integration Services project in Visual Studio.
- Place a Web Services Task from the Control Flow Item on the Control Flow.
- Edit the Task properties. Select <New Connection> from the HttpConnection drop down list.
- Enter a URL with your Server name + “/Callisto_Server/CallistoAdmin.asmx?WSDL”, a valid deFacto admin user name, password, domain. Press Test Connection to validate entries.
- Enter a path to a location to store the WSDL file to be created. Change OverwriteWSDLFile from False to True. Click “Download WSDL” to create WSDL file.
- Click “Input”.
- Select “CallistoAdmin” Service.
- Select “DeployApplication2” Method (Note: Be careful to not select “DeployApplication”.)
- Enter deFacto Application name for Value.
- Click “Output”
- Select OutputType of “File Connection”
- Select File of “<New Connection>”
- Select “Create file” and enter a File name for a text file to contain output.
- Finished. Save the project, and your package will be saved in a dtsx file.
When the package is run, if everything completes successfully the output file will contain the following.
<?xml version="1.0" encoding="utf-16"?>
<string />
- To run the package from the command line use the “dtexec.exe” program which is part of Integration Services. Following is an example of the command and output produced in a Cmd window.
"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\binn\dtexec.exe" /File "C:\Transfer\DeployExample.dtsx"