private void PopulateTables()
{
// Variables used to retrieve and write data
string query;
DataTable tblExtractTables;
// Add ExtractTables
query = "SELECT "
+ " 'Extract_Entrino_' + bet.SourceTableName AS PackageName,"
+ " bet.SequenceName,"
+ " bet.SchemaName,"
+ " bet.SourceSystemName,"
+ " bet.SelectQuery,"
+ " bet.ExtractTableName,"
+ " bet.SourceTableName,"
+ " bet.ArchiveProcedure,"
+ " bet.SequenceContainerName"
+ " FROM META.BimlExtractArchivePackages AS bet";
//+ " where bet.GenerateWithBiml = 1";
tblExtractTables = Data.getData(query, metadataConnectionString);
foreach (DataRow row in tblExtractTables.Rows)
{ // by adding
extractTables.Add(ExtractTable.fillExtractTable(row[0].ToString(), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), row[5].ToString(), row[6].ToString(), row[7].ToString(), row[8].ToString()));
}
}
public static ExtractTable fillExtractTable
(
string PackageName,
string SequenceName,
string SchemaName,
string SourceSystemName,
string SelectQuery,
string ExtractTableName,
string SourceTableName,
string ArchiveProcedure,
string SequenceContainerName
)
{
ExtractTable extractTable = new ExtractTable();
extractTable.PackageName = PackageName;
extractTable.SequenceName = SequenceName;
extractTable.SchemaName = SchemaName;
extractTable.SourceSystemName = SourceSystemName;
extractTable.SelectQuery = SelectQuery;
extractTable.ExtractTableName = ExtractTableName;
extractTable.SourceTableName = SourceTableName;
extractTable.ArchiveProcedure = ArchiveProcedure;
extractTable.SequenceContainerName = SequenceContainerName;
return(extractTable);
}