How to execute SSIS Package from C#.Net? скачать в хорошем качестве

How to execute SSIS Package from C#.Net?

This video will demonstrate how to Execute SSIS package by setting variables in C# .NET. Requirements: Visual studio 2013 Microsoft.Sqlserver.dts.ManagedDTS.dll Procedure: • We need to create source.txt and destination.txt where destination files empty. In this we will copy the data from source file to destination file. • Create ssis package to copy the data. Configure the connection managers for source.txt and destination.txt. • Map the columns from source and destination. • Use ssis package variables for connection manager's connection string property, so that we can manipulate it from C# code. • Execute the package to check if data is getting copied to the file. • Once done with the ssis package, create a project in C#. • Add reference of Microsoft.sqlserver.dts.runtime.dll in the project references. • Create the objects of Application, Package, DTSExecResult, Variables. • Load the package into package object using application's loadpackage method. • execute the package and store return value into DTSExecResult object if it is success or failure • To manipulate the variable values of ssis package use variables object. • Variables is an array of variables present in the ssis package. So to set the values use value property of variables class object. • Again execute the package and store return value into DTSExecResult object if it is success or failure • It is not mendatory to set the values of variables. If you dont set the value from C# code it will take the default value from ssis package. Visit: https://www.paragyte.com/blog/how-to-...