public void RunDataCompareCommandSetTest() { var ts = new SsisTestSuite(); var connRef = new ConnectionRef("TestConn", "Data Source=localhost;Initial Catalog=ssisUnitTestDb;Integrated Security=SSPI", ConnectionRef.ConnectionTypeEnum.AdoNet, "System.Data.SqlClient"); ts.ConnectionList.Add(connRef.ReferenceName, connRef); var dataset = new Dataset( ts, "Test", connRef, false, @"SELECT CAST(1 AS INT) AS ColInt, CAST('Test' AS VARCHAR(50)) AS ColVarChar, CAST(N'Test' AS NVARCHAR(50)) AS ColNVarChar, CAST('1900-01-01' AS DATETIME) AS ColDateTime"); var target = new DataCompareCommand(ts, "Test", dataset, dataset); var actual = (DataCompareCommandResults)target.Execute(); Assert.AreEqual(true, actual.IsDatasetsSame); }