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));
        }
Exemplo n.º 3
0
 static void Main(string[] args)
 {
     EzMyPackage p = new EzMyPackage();
     p.Execute();
     Console.Write(string.Format("Package executed with result {0}\n", p.ExecutionResult));
 }