static void Main(string[] args) { EzMyPackage p = new EzMyPackage(); p.Execute(); Console.Write(string.Format("Package executed with result {0}\n", p.ExecutionResult)); }
public static void Main(string[] args) { // DEMO 3 EzMyPackage <EzSortTransform> p3 = new EzMyPackage <EzSortTransform>("localhost", "AdventureWorks", "select * from Person.Address", "result1.txt"); p3.Transform.EliminateDuplicates = true; p3.Transform.SortOrder["AddressID"] = -1; // sort in descending order p3.SaveToFile("demo3.dtsx"); p3.Execute(); Console.Write(string.Format("Package3 executed with result {0}\n", p3.ExecutionResult)); // Assign SSIS package to EzPackage p3 = new Application().LoadPackage("demo3.dtsx", null); p3.Execute(); Console.Write(string.Format("Package3 executed with result {0}\n", p3.ExecutionResult)); }