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); }
private void CreateConnectionManagers() { //TODO Advance with Expression _ConnectionManager = new Lib.OLEDBConnectionManager("ConnMan", @"Data Source=.;Initial Catalog=Setup;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" ) .AddComponent(_Package); }
public void OLEDBSource(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.OLEDBConnectionManager connection) { var srcprops = new LibDF.OLEDBSourceProperties(connection) .SetSqlCommand("Some SQL"); LibDF.OLEDBSource source = new LibDF.OLEDBSource( "Source Name", srcprops) .AddComponent(dataFlow); }
private void CreateConnectionManagers() { _OLEDBConnectionManager = new Lib.OLEDBConnectionManager("ConnMan", @"Data Source=.;Initial Catalog=Setup;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" ) .AddComponent(_Package); _FlatFileConnectionManager = new Lib.FlatFileConnectionManager("FlatFile Manager") { FileName = "\\notfound.csv", CodePage = 65001, HeaderRowsToSkip = 0, Format = "Delimited", TextQualifier = "\"", ColumnNamesInFirstDataRow = true, HeaderRowDelimiter = Lib.Delimiter.CR_LF, RowDelimiter = Lib.Delimiter.CR_LF, ColumnDelimiter = Lib.Delimiter.Semicolon }.AddComponent(_Package); }
private void OLEDBDestination(LibCF.DataFlow dataFlow, LibDF.OutputWrapper output, Lib.OLEDBConnectionManager connection) { LibDF.OLEDBDestination Destination = new LibDF.OLEDBDestination( "Destination Name", new LibDF.OLEDBDestinationProperties(connection) .SetTableOrViewName("dbo.Test") ).AddComponent(dataFlow); new LibDF.Path(output, Destination.DefaultInput).Connect(dataFlow); Destination.MapColumnsByMatchingNames(); Destination.MapColumn(new LibDF.OLEDBDestinationMapping("ColumnNameA", "ColumnNameB")); }