public void RedirectBatch(IConnectionManager connection)
        {
            //Arrange
            TwoColumnsTableFixture     d2c    = new TwoColumnsTableFixture(connection, "DestLinkError");
            MemorySource <MySimpleRow> source = new MemorySource <MySimpleRow>();

            source.Data = new List <MySimpleRow>()
            {
                new MySimpleRow()
                {
                    Col1 = null, Col2 = "ErrorRecord"
                },
                new MySimpleRow()
                {
                    Col1 = "X2", Col2 = "ErrorRecord"
                },
                new MySimpleRow()
                {
                    Col1 = "1", Col2 = "Test1"
                },
                new MySimpleRow()
                {
                    Col1 = "2", Col2 = "Test2"
                },
                new MySimpleRow()
                {
                    Col1 = "3", Col2 = "Test3 - good, but in error batch"
                },
                new MySimpleRow()
                {
                    Col1 = null, Col2 = "ErrorRecord"
                },
                new MySimpleRow()
                {
                    Col1 = "3", Col2 = "Test3"
                },
            };
            DBDestination <MySimpleRow>     dest      = new DBDestination <MySimpleRow>(connection, "DestLinkError", batchSize: 2);
            MemoryDestination <ETLBoxError> errorDest = new MemoryDestination <ETLBoxError>();

            //Act
            source.LinkTo(dest);
            dest.LinkErrorTo(errorDest);
            source.Execute();
            dest.Wait();
            errorDest.Wait();

            //Assert
            d2c.AssertTestData();
            Assert.Collection <ETLBoxError>(errorDest.Data,
                                            d => Assert.True(!string.IsNullOrEmpty(d.RecordAsJson) && !string.IsNullOrEmpty(d.ErrorText)),
                                            d => Assert.True(!string.IsNullOrEmpty(d.RecordAsJson) && !string.IsNullOrEmpty(d.ErrorText))
                                            );
        }