private LibCF.ForEachLoop AddForEachFileInfoLoop(LibCF.ISequence seq, LibCF.Package package, Lib.Variable variable) { LibCF.ForEachLoop felc = new LibCF.ForEachLoop("Loop name").AddComponent(seq) .SetADOEnumerator(package, variable) .AddVariableMapping(variable, 0); return(felc); }
public virtual void AddConnectionManagerWithExpression(LibCF.Package package) { Lib.Expression expression = new Lib.Expression(Lib.Expression.ConnectionStringProperty, "connection string"); Lib.OLEDBConnectionManager ConnectionManager = new Lib.OLEDBConnectionManager("Name", "Default connection string") .AddComponent(package) .AddExpression(expression); }
public void EventHandler(LibCF.Package package, Lib.ConnectionManager connection) { LibCF.Sequence seq = new LibCF.Sequence("Sequence") .AddComponent(package); Lib.EventHandlerWrap postExecute = seq.GetPostExecuteEventHandler(); LibCF.SQLTask sqlTask = new LibCF.SQLTask("sql task", connection) .AddComponent(seq) .AddDirectInput("SQL"); postExecute.AddTask(sqlTask); }
public void CreatePackage(string packageName) { _Package = new LibCF.Package(packageName, LibCF.ProtectionLevel.EncryptSensitiveWithUserKey); _Package.CreatePackage(); }
public void AddParameter(LibCF.Package package) { Lib.PackageParameter Parameter = new Lib.PackageParameter("Name", TypeCode.Int32).AddComponent(package); }
//Control Flow Snippets private void AddVariable(LibCF.Package package) { Lib.Variable Variable = new Lib.Variable("VarName", "Default", Lib.DataType.WSTR).AddComponent(package); }