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