June 24, 2015 by Anuraj
.Net .Net 4.0 ASP.Net ASP.Net MVC SQL Server Visual Studio
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications.
You can execute SSIS package from C# using following snippet.
This will execute the package and return results like Success or Failure. But in Failure scenarios, it won’t give any useful information for identifying the failure. You can implement an EventListener class to get more detailed execution information. Here is sample implementation.
Happy Programming :)
Copyright © 2024 Anuraj. Blog content licensed under the Creative Commons CC BY 2.5 | Unless otherwise stated or granted, code samples licensed under the MIT license. This is a personal blog. The opinions expressed here represent my own and not those of my employer. Powered by Jekyll. Hosted with ❤ by GitHub