public void TestCopyFileToConnection() { var file1 = Path.GetTempFileName(); File.WriteAllText(file1, "f1,f2,f3\nv1,v2,v3"); var element = new ProcessBuilder("CopyFile") .Connection("output") .Provider("SqlServer") .Database("TestOutput") .Action("Copy") .From(file1) .To("output") .Process(); var process = ProcessFactory.CreateSingle(element, new TestLogger()); process.ExecuteScaler(); var expected = Common.CleanIdentifier(Path.GetFileNameWithoutExtension(file1)); var sqlServer = element.GetDefaultOf<TflConnection>(c => { c.Name = "test"; c.Provider = "sqlserver"; c.Database = "TestOutput"; }).Connection; var rows = sqlServer.GetConnection().Query(string.Format("SELECT f1, f2, f3 FROM {0}", expected)).ToArray(); Assert.AreEqual(1, rows.Length); Assert.AreEqual("v1", rows[0].f1); Assert.AreEqual("v2", rows[0].f2); Assert.AreEqual("v3", rows[0].f3); }