public void When_Valid_Data_Received() { var testFile = Path.Combine(TestContext.CurrentContext.TestDirectory, $"LoadData-{Guid.NewGuid()}.csv"); var writer = new FileWriter(testFile); // <--- YOU need to write this writer.WriteRow("a_known_value"); writer.WriteRow("a_known_value"); writer.WriteRow("a_known_value"); writer.WriteRow("a_known_value"); var runner = new SSisPackageRunner(); // <--- YOU need to write this runner.Run(Path.Combine(TestContext.CurrentContext.TestDirectory, "PackageUnderTest.dtsx")); // <--- YOU need to write this // --------- YOU need to write this // | var tableCount = // V new TableReader().GetCount( "select count(*) from a table where a value is '99' and another value is something like '%fff%'"); Assert.AreEqual(4, tableCount); }