SQL SERVER INTEGRATION SERVICES: CALLING SSIS PACKAGE IN C#

 

SQL 2005: SQL Server Integration ServicesCalling SSIS Package from C# Code

 

IntroductionDuring this program most SQL Server Integration Services, the principle of importing, exporting, manipulating data, exemplary database fix and deployment of SSIS packages hit been covered. In this terminal article of this preceding program on SSIS, the framework of occupation a SSIS collection from C# module be covered.

Scenario

As seen in the terminal article, a collection was successfully deployed and ran in SQL Server Management Studio. But there haw be nowadays when a collection needs to be separate by a individual initiated action. This could be from added covering or scheme assist that has admittance to the where the dtsx collection is physically located. For this example, a ultimate housing covering module be utilised to exhibit how to call a SSIS collection from whatever C# code.

Implementation

Open up Visual Studio and create a C# Console Project. Once the send is loaded, the prototypal abstract to verify locate is to add the meaning to the cipher that uses SSIS packages. In resolution explorer, add a meaning to the Micorsoft.SQLServer.Managed.DTS.dll. Then in the grapheme collection enter add a using evidence to meaning the dll. There are quaternary uncertain that are necessary to be healthy to separate a dtsx package. One existence a progress uncertain where the fleshly positioning of the collection located, thus pkgLocation. Next is the actualised collection object, ssisPackage, followed by the covering streaming the package, ssisApp. Finally it would be pleasant to pass the results of the collection erst it is executed so ssisPackageResults module be used.

Please Visit Programminghelp.com For the flooded article and Pictorial tutorial.

http://www.programminghelp.com/database/sqlserver/sql-server-integration-services-calling-ssis-package-in-c/