Abstract
This chapter shows you how to execute a package from a .NET application, which could be a web application, a web service, a Windows service, or a Windows application. Since there are two deployment models, there are also two different ways to execute packages; however, there is one requirement: you need SQL Server Integration Services installed on the same machine as your application. The packages will run on this machine. If this is not possible in your situation, you could create a web service on machine A to execute packages locally and then call that web service from an application that runs on machine B. Another alternative is to let your code on machine B execute a remote SQL Server Agent job on machine A to execute a package locally. In both cases, the application runs on machine B, but the package runs on machine A.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Joost van Rossum and Régis Baccaro
About this chapter
Cite this chapter
van Rossum, J., Baccaro, R. (2015). Package Execution from .NET. In: Extending SSIS with .NET Scripting. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0638-6_19
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0638-6_19
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0639-3
Online ISBN: 978-1-4842-0638-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books