/// <summary>
/// Creates a Flat File Connection Manager.
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="project"></param>
/// <param name="package"></param>
public ISExcelConnectionManager(
string name,
ISProject project = null,
ISPackage package = null)
: base("", name, "EXCEL", project, package)
{
}
/// <summary>
/// ctor for creating a Sql Mobile Connection Manager
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="project"></param>
/// <param name="package"></param>
public ISSqlMobileConnectionManager(
string connectionString,
string name,
ISProject project = null,
ISPackage package = null) : base(connectionString, name, "SQLMOBILE", project, package)
{
}
/// <summary>
/// Constructor that accepts the type of executable (Object Moniker), a name of the executable and the immediate parent.
/// In addition to assigning the MainPipe object, we also get a reference to the actual Package that contains this data flow task
/// </summary>
/// <param name="objectMoniker">The type of the Executable</param>
/// <param name="displayName">The name of the executable</param>
/// <param name="immediateContainer">The immediate parent of the executable</param>
public ISDataFlowTask(string displayName, ISContainer immediateContainer, ISProject project = null, ISPackage package = null) :
base("Microsoft.Pipeline", displayName, immediateContainer)
{
MainPipe = TaskHost.InnerObject as MainPipe;
/*if (MainPipe == null)
* {
* Console.WriteLine("Main Pipe is null");
* } else
* {
* Console.WriteLine("MainPipe NOT null");
* }*/
if (package == null)
{
RootPackage = (ISContainer.GetActualPackage(immediateContainer).Container) as Microsoft.SqlServer.Dts.Runtime.Package;
ParentPackage = (ISPackage)(RootPackage as Microsoft.SqlServer.Dts.Runtime.Package);
}
else
{
ParentPackage = package;
RootPackage = package.Package;
}
if (project == null)
{
if (ParentPackage.Project == null)
{
ParentPackage.Project = project;
}
}
else
{
ParentPackage.Project = project;
}
}
/// <summary>
/// ctor for creating a OLAP Connection Manager
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="project"></param>
/// <param name="package"></param>
public ISOLAPConnectionManager(
string connectionString,
string name,
ISProject project = null,
ISPackage package = null) : base(connectionString, name, "MSOLAP90", project, package)
{
}
/// <summary>
/// ctor for creating a ADO.Net Connection Manager
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="project"></param>
/// <param name="package"></param>
public ISAdoNetConnectionManager(
string connectionString,
string name,
ISProject project = null,
ISPackage package = null) : base(connectionString, name, "ADO.NET", project, package)
{
}
/// <summary>
/// ctor for creating a OleDb Connection Manager
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="project"></param>
/// <param name="package"></param>
public ISOledbConnectionManager(
string connectionString,
string name,
ISProject project = null,
ISPackage package = null) : base(connectionString, name, "OLEDB", project, package)
{
}
/// <summary>
/// Creates a Flat File Connection Manager.
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="project"></param>
/// <param name="package"></param>
public ISFlatFileConnectionManager(
string connectionString,
string name,
ISProject project = null,
ISPackage package = null)
: base(connectionString, name, "FLATFILE", project, package)
{
}
/// <summary>
/// ctor that accepts a ISPackage object
/// </summary>
/// <param name="package">The package to which the parameter is to be added or is already added</param>
/// <param name="parameterName">Name of the parameter</param>
/// <param name="paramTypeCode">Typecode of the parameter</param>
public ISParameter(ISPackage package, string parameterName, TypeCode paramTypeCode = TypeCode.Empty)
{
if (package.Parameters_m != null)
{
if (package.Parameters_m.Contains(parameterName))
{
Parameter = package.Parameters_m[parameterName];
}
else
{
Parameter = package.Parameters_m.Add(parameterName, paramTypeCode);
}
}
else
{
Parameter = package.Parameters_m.Add(parameterName, paramTypeCode);
}
}
internal ISBaseFlatFileConnectionManager(string connectionString, string name, string creationName, ISProject project = null, ISPackage package = null)
: base(connectionString, name, creationName, project, package)
{
}
public void AddPackage(ISPackage package, bool reusePackageIfExists = true)
{
package.AddToProject(this, reusePackageIfExists);
}
internal static ISBaseFlatFileConnectionManager GetConnectionManager(string connectionManagerName, ISProject ssisProject = null, ISPackage ssisPackage = null)
{
ISBaseFlatFileConnectionManager connMgr = null;
if (ssisProject != null)
{
foreach (ConnectionManagerItem cmi in ssisProject.ConnectionManagerItems_m)
{
if (cmi.ConnectionManager.Name == connectionManagerName)
{
connMgr = (ISBaseFlatFileConnectionManager)cmi.ConnectionManager;
}
}
}
return(connMgr);
}
/// <summary>
/// Base ctor for internal use. Use this internally outside of this class.
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="creationName"></param>
/// <param name="project"></param>
/// <param name="package"></param>
internal ISConnectionManager(string connectionString, string name, string creationName, ISProject project = null, ISPackage package = null)
: this(connectionString, name, creationName,
project == null ? null : project.Project,
package == null ? null : package.Package)
{
}
/// <summary>
/// Base ctor for createing Database Connection Managers. used internally within this assembly.
/// </summary>
/// <param name="connectionString"></param>
/// <param name="name"></param>
/// <param name="creationName"></param>
/// <param name="project"></param>
/// <param name="package"></param>
internal ISDatabaseParametersConnectionManager(string connectionString, string name, string creationName, ISProject project, ISPackage package)
: base(connectionString, name, creationName, project, package)
{
}
