Richard

  • Home
All Posts Links About

Richard

  • Home

Execute SSIS Package in C# Apps

2008-03-04

Add referrence to Micosoft.SQLServer.ManagedDTS.dll. It is in your SQL Server Program Files Folder\SDK\Assemblies.

using Microsoft.SqlServer.Dts.Runtime;

namespace ExecuteSSIS
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
//
// Load package from file system
//
Package package = app.LoadPackage(@”c:\myPackage.dtsx”, null);
package.ImportConfigurationFile(@”c:\myPackage.dtsConfig”);
//Pass parameters
Variables vars = package.Variables;
vars[“variable”].Value = “values”;
DTSExecResult result = package.Execute();
Console.WriteLine(“Package Execution results: {0}”,result.ToString());

//
// Load package from Sql Server
//
Package package2 = app.LoadFromSqlServer(
“myPackage”,”server_name”, “sa”, “password”, null);
package2.ImportConfigurationFile(@”c:\myPackage.dtsConfig”);
//Pass parameters
Variables vars2 = package2.Variables;
vars2[“variable”].Value = “value”;
DTSExecResult result2 = package2.Execute();
Console.WriteLine(“Package Execution results: {0}”,
result2.ToString());
}
}
}

  • SQL Server
  • SSIS

扫一扫,分享到微信

微信分享二维码
SQL Server 2008 Feb CTP
Use Active Directory to Authenticate
© 2017 Richard
Hexo Theme Yilia by Litten
  • All Posts
  • Links
  • About

tag:

  • ASPNET
  • DotNetCore
  • VS2015
  • Service Pack 2
  • SQL Server
  • Database Restore
  • SQL Server 2008 R2
  • GitHub
  • Blog
  • Trace Flags
  • SQL Server 2017
  • Linux
  • SQL Server Management Studio
  • SSMS
  • SQL Server 2014

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录(注意不是yilia根目录)执行以下命令:
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置:

      jsonContent:
        meta: false
        pages: false
        posts:
          title: true
          date: true
          path: true
          text: false
          raw: false
          content: false
          slug: false
          updated: false
          comments: false
          link: false
          permalink: false
          excerpt: false
          categories: false
          tags: true
    

  • SQL Server Updates
  • SQLBlog.com
  • SQL Server Central
  • My Old Blog Site 1
  • My Old Blog Site 2
  • Unicode Character Map for Windows
  • Dev Tool List (From Scott Hanselman)
Improve daily life using IT techs.