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(); }
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(); }