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"));
}
