public PACKAGE_PSA(DATAOBJECT d)
: base(d)
{
this.packageType = "PSA";
this.Name = this.tableName();
this.addConnection("Commercial_STG", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("STAGE").NAME);
this.addConnection("Commercial_PSA", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("PSA").NAME);
this.addConnection("Commercial_RUN", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("RUN").NAME);
this.addConnection("Commercial_MATCH", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("MATCH").NAME);
this.addConnection("Commercial_META", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("META").NAME);
this.addVariable("Audit::RowsUpdated");
this.addVariable("Audit::RowsInserted");
EzDataFlow ExtractAllRecords = new PSADataFlow(this, this);
ExtractAllRecords.Name = "Import Staging Data To PSA";
this.SaveToFile(this.fileName());
this.addConfigurations();
this.addLogging(ExtractAllRecords.Name);
//TODO Update Inactive Records
//TOO Delete Processed Inactive Rows
}
public PACKAGE_STAGE(DATAOBJECT d)
: base(d)
{
this.packageType = "STAGE";
this.Name = this.tableName("STAGE");
this.addConnection("Commercial_STG", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("STAGE").NAME);
this.addConnection("Commercial_PSA", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("PSA").NAME);
this.addConnection("Commercial_RUN", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("RUN").NAME);
this.addConnection("MATCH", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("MATCH").NAME);
this.addConnection("Commercial_META", this.t.SSMS.SERVERNAME, this.t.getDatabaseByLayer("META").NAME);
this.addConnection("Source", this.d.ds.SERVERNAME, this.d.ds.DATABASENAME);
this.addVariable("Audit::RowsMatched");
this.addVariable("Audit::RowsInserted");
this.addVariable("Audit::RowsUpdated");
this.addVariable("Audit::RowsDeleted");
//Clear stage table for clean full load of source data
EzExecuteSQLTask TruncateStageTable = new EzExecuteSQLTask(this);
TruncateStageTable.Name = "Truncate Stage Table";
TruncateStageTable.SqlStatementSource = "truncate table " + this.tableName("STAGE");
TruncateStageTable.Connection = this.Conns["Commercial_STG"];
EzDataFlow ExtractAllRecords = new StageDataFlow(this, this);
ExtractAllRecords.Name = "Extract All Records";
ExtractAllRecords.AttachTo(TruncateStageTable);
this.SaveToFile(this.fileName());
this.addConfigurations();
this.addLogging(ExtractAllRecords.Name);
}
