请问在C#中如何创建ssis包,要求可以自己选择表,像SQLServer的一样。谢谢~
解决方案 »
- 中断for循环问题
- 想用winfrom+2008+c#写个程序,最小化驻留在任务栏上,用于每隔1小去运行一次updata.asp。小弟先感谢前辈了!
- 两个ListView,将一个ListView中的数据 ,根据所选项 拖到另一个ListView中去
- BringToFront()去掉
- 请教高手~~如何获取到指定一个文件的大小啊!!在C#里
- 关于类继承的问题
- 请问如何在程序里对sql语句实现绑定变量,来减少对oracle数据库的解析?
- Socket双向心跳包问题
- 使用 SqlDataAdaper 删除数据库记录失败,求教~~~~~
- 关于远程处理,请大家一定要帮忙啊
- windows.forms中textbox.text属性和thread的问题(高手来看看)
- winform 开发中,有没有和Webform 中类似 web.config 文件一样,可以存放数据库路径等配置信息??
using Microsoft.SqlServer.Dts.Runtime;
namespace Microsoft.SqlServer.Dts.Samples
{
class CreatingAPackage
{
Package package;
public CreatingAPackage()
{
package = new Package();
}
}
}using System;
using Microsoft.SqlServer.Dts.Runtime;
namespace Microsoft.SqlServer.Dts.Samples
{
class ApplicationTests
{
static void Main(string[] args)
{
// The variable pkg points to the location of the
// ExecuteProcess package sample that was installed with
// the SSIS samples.
string pkg = @"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\1033\DataTransformationServices\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"; Application app = new Application();
Package p = app.LoadPackage(pkg, null);
// Now that the package is loaded, we can query on
// its properties.
int n = p.Configurations.Count;
DtsProperty p2 = p.Properties["VersionGUID"];
DTSProtectionLevel pl = p.ProtectionLevel; Console.WriteLine("Number of configurations = " + n);
Console.WriteLine("VersionGUID = " + p2);
Console.WriteLine("ProtectionLevel = " + pl);
}
}
}