/// <summary>
/// Add an Ado.Net package in project
/// </summary>
/// <typeparam name="TransformType">Transform Component Type</typeparam>
/// <param name="srcserver">source server name</param>
/// <param name="srcdb">source database name</param>
/// <param name="srcsql">source sql command statment</param>
/// <param name="transform">transform component</param>
/// <param name="destserver">destination server name</param>
/// <param name="destdb">destination database name</param>
/// <param name="desttable">destination table name</param>
/// <returns>package stream name</returns>
public string AddAdoNetPackage <TransformType>(string srcserver, string srcdb, string srcsql,
TransformType transform, string destserver, string destdb, string desttable)
where TransformType : EzComponent
{
Debug.Assert(!string.IsNullOrEmpty(srcserver), @"The source server could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(srcdb), @"The source database could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(srcsql), @"The source sql command statement could not be nullable.");
Debug.Assert(null != transform, @"The transform component could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(destserver), @"The destination server could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(destdb), @"The destination database could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(desttable), @"The destination table could not be nullable.");
//construct a transform package
EzTransformPackage <EzAdoNetSource, EzSqlAdoNetCM, TransformType, EzAdoNetDestination, EzSqlAdoNetCM> package =
new EzTransformPackage <EzAdoNetSource, EzSqlAdoNetCM, TransformType, EzAdoNetDestination, EzSqlAdoNetCM>();
package.SrcConn.SetConnectionString(srcserver, srcdb);
package.Source.SqlCommand = srcsql;
package.Transform = transform;
package.DestConn.SetConnectionString(destserver, destdb);
package.Dest.Table = desttable;
//add this package in project
return(AddPackage(package));
}
/// <summary>
/// Add a flat file source and oledb destination package with tranform in project
/// </summary>
/// <typeparam name="TransformType">Transform Component Type</typeparam>
/// <param name="srcfile">source flat file</param>
/// <param name="transform">transform component</param>
/// <param name="destserver">destination server name</param>
/// <param name="destdb">destination database name</param>
/// <param name="desttable">destination table name</param>
/// <returns>package stream name</returns>
public string AddFlatFileToOleDbPackage <TransformType>(string srcfile, TransformType transform,
string destserver, string destdb, string desttable)
where TransformType : EzComponent
{
Debug.Assert(!string.IsNullOrEmpty(srcfile), @"The source file could not be nullable.");
Debug.Assert(null != transform, @"The transform component could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(destserver), @"The destination server could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(destdb), @"The destination database could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(desttable), @"The destination table could not be nullable.");
//construct a transform pacakge
EzTransformPackage <EzFlatFileSource, EzFlatFileCM, TransformType, EzOleDbDestination, EzSqlOleDbCM> package =
new EzTransformPackage <EzFlatFileSource, EzFlatFileCM, TransformType, EzOleDbDestination, EzSqlOleDbCM>();
package.SrcConn.ConnectionString = srcfile;
package.Transform = transform;
package.DestConn.SetConnectionString(destserver, destdb);
package.Dest.Table = desttable;
return(AddPackage(package));
}
/// <summary>
/// Add an tranform package in project
/// </summary>
/// <typeparam name="SourceType">Source Adapter Type</typeparam>
/// <typeparam name="SourceConnectionType">Source Connection Manager Type</typeparam>
/// <typeparam name="TranformType">Tranform Component Type</typeparam>
/// <typeparam name="DestinationType">Destination Adapter Type</typeparam>
/// <typeparam name="DestinationConnectionType">Destination Connection Manager Type</typeparam>
/// <param name="source">source adapter</param>
/// <param name="srcconn">source connection manager</param>
/// <param name="transform">tranform component</param>
/// <param name="destination">destination adapter</param>
/// <param name="destconn">destination connection manager</param>
/// <returns>package stream name</returns>
public string AddPackage <SourceType, SourceConnectionType, TranformType, DestinationType, DestinationConnectionType>
(SourceType source,
SourceConnectionType srcconn,
TranformType transform,
DestinationType destination,
DestinationConnectionType destconn)
where SourceType : EzAdapter
where SourceConnectionType : EzConnectionManager
where TranformType : EzComponent
where DestinationType : EzAdapter
where DestinationConnectionType : EzConnectionManager
{
Debug.Assert(null != source, @"The source component could not be nullable.");
Debug.Assert(null != srcconn, @"The source connection could not be nullable.");
Debug.Assert(null != transform, @"The transform component could not be nullable.");
Debug.Assert(null != destination, @"The destination component could not be nullable.");
Debug.Assert(null != destconn, @"The destination connection could not be nullable.");
//construct a transform package
EzTransformPackage <SourceType, SourceConnectionType, TranformType, DestinationType, DestinationConnectionType> package =
new EzTransformPackage <SourceType, SourceConnectionType, TranformType, DestinationType, DestinationConnectionType>();
package.Source = source;
package.SrcConn = srcconn;
package.Transform = transform;
package.Dest = destination;
package.DestConn = destconn;
//Add this package in project
return(AddPackage(package));
}
/// <summary>
/// Add an oledb source and flat file destination package with transform in project
/// </summary>
/// <typeparam name="TransformType">Transform Component Type</typeparam>
/// <param name="srcserver">source server name</param>
/// <param name="srcdb">source database name</param>
/// <param name="srcsql">source sql command statment</param>
/// <param name="transform">transform component</param>
/// <param name="file">destination flat file</param>
/// <returns>package stream name</returns>
public string AddOleDbToFilePackage <TransformType>(string srcserver, string srcdb, string srcsql,
TransformType transform, string destfile)
where TransformType : EzComponent
{
Debug.Assert(!string.IsNullOrEmpty(srcserver), @"The source server could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(srcdb), @"The source database could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(srcsql), @"The source sql command statement could not be nullable.");
Debug.Assert(null != transform, @"The transform component could not be nullable.");
Debug.Assert(!string.IsNullOrEmpty(destfile), @"The destination file could not be nullable.");
//construct a transform pacakge
EzTransformPackage <EzOleDbSource, EzSqlOleDbCM, TransformType, EzFlatFileDestination, EzFlatFileCM> package =
new EzTransformPackage <EzOleDbSource, EzSqlOleDbCM, TransformType, EzFlatFileDestination, EzFlatFileCM>();
package.SrcConn.SetConnectionString(srcserver, srcdb);
package.Source.SqlCommand = srcsql;
package.Transform = transform;
package.DestConn.ConnectionString = destfile;
package.Dest.Overwrite = true;
package.Dest.DefineColumnsInCM();
return(AddPackage(package));
}
