public void Sql_ExecuteSetup_TableCreated()
{
//Create table
dbUnderTest.ExecuteAdhoc($"Create table test(Id Int);");
var result = dbUnderTest.GetActual("Select count(*) from Information_Schema.Tables WHERE Table_Name = 'Test'");
Assert.That(result, Is.EqualTo(1));
}
public void DeployProjectToCatalogTask_Execute_DeploysProject()
{
//act
string args = $@"SsisBuild.proj /t:SSISDeploy /p:SSISProj=TestSsisProject,Configuration=Development,ProjectName=TestSsisProject,SSISServer={ssisServer},FolderName=NewFolder,SsisVersion=2017";
RunDeployment(args);
//Assert
var actual = ssisdb.GetActual(@"Select 1 From catalog.projects p
join catalog.folders f on p.folder_id = f.folder_id
where f.name = 'NewFolder'
and p.name = 'TestSsisProject'");
Assert.That(actual, Is.EqualTo(1));
}