如何在MS SQL Server 2008中以编程方式创建数据流任务脚本组件。
下面给出的链接包含了在SSIS中创建自定义转换组件的Microsoft动手实验。该文件与SSIS 2005有关,但逻辑也应适用于SSIS 2008。
SQL Server Integration Services (SSIS) Hands on Training - Creating Custom Components
希望对你有帮助。
这是用编程方式创建ScriptTask的代码。
Package pkg = new Package();
pkg.Executables.Add("STOCK:ScriptTask");
TaskHost th = (TaskHost)exec;
ScriptTask task = (ScriptTask)th.InnerObject;
task.ScriptProjectName = "YourProjectName.csproj”; // (or vbproj)
th.Name = name;
task.ScriptLanguage = CS_SCRIPT;
task.ReadWriteVariables = “User::Var1,User::Var2”; //Comma separated list of variables
task.ReadOnlyVariables = rvars;
task.ScriptingEngine.LoadScriptSolution(path); // This method loads solution and builds
task.ScriptingEngine.CloseIDE(true); // closes IDE and saves binary code