Prerequisites:
- SQL SERVER SSIS Package
- Visual C# Express Edition
File Name: Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Configuration;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Smo.Agent;
using Microsoft.SqlServer.Management.Common;
using System.Data.SqlClient;
namespace SSIS_Button_Application
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
private void Button1_Click(object sender, EventArgs e)
{
// Load package from file system
Package package = app.LoadPackage("c:\\Folderpath\\filename.dtsx", null);
package.ImportConfigurationFile("C:\\folderpath\\filename.dtsConfig");
Variables vars = package.Variables;
vars["variablename used in table"].Value = "user variable value";
DTSExecResult result = package.Execute();
Console.WriteLine("Package Execution results: {0}", result.ToString());
}
}
}
Voila you have your official first .dtsx job executed once you compile your c# code. GOOD LUCK GUYS. Ofcourse this is just a starting point. You can build your own sweet and big application very easily. God be with you all.