public EzMyPackage() : base() { // Connection managers SrcConn = new EzSqlOleDbCM(this); SrcConn.SetConnectionString(Environment.MachineName, "AdventureWorks"); MatchCM = new EzFlatFileCM(this); MatchCM.ConnectionString = "matchcm.txt"; NoMatchCM = new EzFlatFileCM(this); NoMatchCM.ConnectionString = "nomatchcm.txt"; ErrorCM = new EzFlatFileCM(this); ErrorCM.ConnectionString = "errorcm.txt"; RefConn = new EzSqlOleDbCM(this); RefConn.SetConnectionString(Environment.MachineName, "AdventureWorks"); // Creating Dataflow Source = new EzOleDbSource(DataFlow); Source.Connection = SrcConn; Source.SqlCommand = "select * from HumanResources.Employee"; Lookup = new EzLookup(DataFlow); Lookup.AttachTo(Source); Lookup.OleDbConnection = RefConn; Lookup.SqlCommand = "select * from HumanResources.EmployeeAddress"; Lookup.SetJoinCols("EmployeeID,EmployeeID"); Lookup.SetPureCopyCols("AddressID"); Lookup.NoMatchBehavor = NoMatchBehavior.SendToNoMatchOutput; Lookup.OutputCol("AddressID").TruncationRowDisposition = DTSRowDisposition.RD_RedirectRow; SortMatch = new EzSortTransform(DataFlow); SortMatch.AttachTo(Lookup, 0, 0); SortMatch.SortOrder["EmployeeID"] = 1; // sort in ascending order SortMatch.SortOrder["AddressID"] = -2; // sort in descending order SortNoMatch = new EzSortTransform(DataFlow); SortNoMatch.AttachTo(Lookup, 1, 0); SortNoMatch.SortOrder["EmployeeID"] = 1; // sort in ascending order ErrorDest = new EzFlatFileDestination(DataFlow); ErrorDest.AttachTo(Lookup, 2, 0); ErrorDest.Connection = ErrorCM; ErrorDest.DefineColumnsInCM(); // configure connection manager to have all input columns defined in the resulting file MatchDest = new EzFlatFileDestination(DataFlow); MatchDest.AttachTo(SortMatch); MatchDest.Connection = MatchCM; MatchDest.DefineColumnsInCM(); NoMatchDest = new EzFlatFileDestination(DataFlow); NoMatchDest.AttachTo(SortNoMatch); NoMatchDest.Connection = NoMatchCM; NoMatchDest.DefineColumnsInCM(); }
public EzMyDataFlow(EzContainer parent) : base(parent) { // Connection managers SrcConn = new EzSqlOleDbCM(Package, "SrcConn"); SrcConn.SetConnectionString(Environment.MachineName, "AdventureWorks"); MatchCM = new EzFlatFileCM(Package, "MatchCM"); MatchCM.ConnectionString = "matchcm.txt"; NoMatchCM = new EzFlatFileCM(Package, "NoMatchCM"); NoMatchCM.ConnectionString = "nomatchcm.txt"; ErrorCM = new EzFlatFileCM(Package, "ErrorCM"); ErrorCM.ConnectionString = "errorcm.txt"; RefConn = new EzSqlOleDbCM(Package, "RefConn"); RefConn.SetConnectionString(Environment.MachineName, "AdventureWorks"); // Creating Dataflow Source = new EzOleDbSource(this); Source.Connection = SrcConn; Source.SqlCommand = "select * from HumanResources.Employee"; Lookup = new EzLookup(this); Lookup.AttachTo(Source); Lookup.OleDbConnection = RefConn; Lookup.SqlCommand = "select * from HumanResources.EmployeeAddress"; Lookup.SetJoinCols("EmployeeID,EmployeeID"); Lookup.SetPureCopyCols("AddressID"); Lookup.NoMatchBehavor = NoMatchBehavior.SendToNoMatchOutput; Lookup.OutputCol("AddressID").TruncationRowDisposition = DTSRowDisposition.RD_RedirectRow; SortMatch = new EzSortTransform(this); SortMatch.AttachTo(Lookup, 0, 0); SortMatch.SortOrder["EmployeeID"] = 1; // sort in ascending order SortMatch.SortOrder["AddressID"] = -2; // sort in descending order SortNoMatch = new EzSortTransform(this); SortNoMatch.AttachTo(Lookup, 1, 0); SortNoMatch.SortOrder["EmployeeID"] = 1; // sort in ascending order ErrorDest = new EzFlatFileDestination(this); ErrorDest.AttachTo(Lookup, 2, 0); ErrorDest.Connection = ErrorCM; ErrorDest.DefineColumnsInCM(); // configure connection manager to have all input columns defined in the resulting file MatchDest = new EzFlatFileDestination(this); MatchDest.AttachTo(SortMatch); MatchDest.Connection = MatchCM; MatchDest.DefineColumnsInCM(); NoMatchDest = new EzFlatFileDestination(this); NoMatchDest.AttachTo(SortNoMatch); NoMatchDest.Connection = NoMatchCM; NoMatchDest.DefineColumnsInCM(); }