public EzMyPackage(string srv, string db, string sql, string file) : base()
 {
     SrcConn.SetConnectionString(srv, db);
     Source.SqlCommand         = sql;
     DestConn.ConnectionString = file;
     Dest.Overwrite            = true;
     Dest.DefineColumnsInCM();
 }
Beispiel #2
0
        public EzOleDbToOleDb(string srcSvr, string srcDb, string srcTable, string dstSvr, string dstDb, string dstTable)
            : base()
        {
            SrcConn.SetConnectionString(srcSvr, srcDb);
            Source.Table = srcTable;

            DestConn.SetConnectionString(dstSvr, dstDb);
            Dest.Table = dstTable;
        }
 public EzLoopSortPackage(string srv, string db, string table, string file)
     : base()
 {
     SrcConn.SetConnectionString(srv, db);
     Source.Table              = table;
     Source.AccessMode         = AccessMode.AM_OPENROWSET;
     DestConn.ConnectionString = file;
     Dest.Overwrite            = true;
     Dest.DefineColumnsInCM();
 }
 public EzOleDbToFilePackage(string srv, string db, string table, string file)
     : base()
 {
     SrcConn.SetConnectionString(srv, db);
     Source.Table = table;
     DestConn.ConnectionString = file;
     Dest.Overwrite            = true;
     // This method defines the columns in FlatFile connection manager which have the same
     // datatypes as flat file destination
     Dest.DefineColumnsInCM();
 }