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