/// <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>
/// 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 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>
/// 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>
/// 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 ISProject object
/// </summary>
/// <param name="project">The project 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(ISProject project, string parameterName, TypeCode paramTypeCode = TypeCode.Empty)
{
if (project.Parameters_m != null)
{
if (project.Parameters_m.Contains(parameterName))
{
Parameter = project.Parameters_m[parameterName];
}
else
{
Parameter = project.Parameters_m.Add(parameterName, paramTypeCode);
}
}
else
{
Parameter = project.Parameters_m.Add(parameterName, paramTypeCode);
}
}
/// <summary>
/// Check if a package with the given name already exist in the package.
/// If it exists:
/// if the reuse flag is true, then assign the found Package to the relevant package variable.
/// (in case of reuse = true) since the package variable is assgined to an existing package, that means that whatever changes made to the package variable before calling this method are overwritten with the existing package's properties
/// If the package does not exist (with the same name) or the reuse flag is flag, then a new package is created
/// </summary>
/// <param name="packageName"></param>
/// <param name="project"></param>
/// <param name="reusePackageIfExists"></param>
private void AddToProject(string packageName, ISProject project, bool reusePackageIfExists = true)
{
bool packageExistsInProject = false;
for (int p = 0; p < project.PackageItems_m.Count; p++)
{
if (project.PackageItems_m[p].Package.Name == packageName)
{
packageExistsInProject = true;
if (reusePackageIfExists)
{
Package = project.PackageItems_m[p].Package;
}
}
}
if (packageExistsInProject && reusePackageIfExists == false)
{
project.PackageItems_m.Remove(packageName + ".dtsx");
packageExistsInProject = false;
}
if (!(packageExistsInProject))
{
if (Package == null)
{
Package = new Package();
Package.Name = packageName;
}
project.PackageItems_m.Add(Package, packageName + ".dtsx");
}
Executable = (Executable)Package;
Container = (DtsContainer)Package;
EventsProvider = (EventsProvider)Package;
EventsProviderAsIDTSSequence = (IDTSSequence)Package;
}
/// <summary>
/// Check if a package with the given name already exist in the package.
/// If it exists:
/// if the reuse flag is true, then assign the found Package to the relevant package variable.
/// (in case of reuse = true) since the package variable is assgined to an existing package, that means that whatever changes made to the package variable before calling this method are overwritten with the existing package's properties
/// If the package does not exist (with the same name) or the reuse flag is flag, then a new package is created
/// </summary>
/// <param name="project"></param>
/// <param name="reusePackageIfExists"></param>
public void AddToProject(ISProject project, bool reusePackageIfExists = true)
{
AddToProject(Name, project, reusePackageIfExists);
}
/// <summary>
/// A constructor that accepts a Package name and parent project.
/// Check if a package with the given name already exist in the package.
/// If it exists:
/// if the reuse flag is true, then assign the found Package to the relevant package variable.
/// If the package does not exist (with the same name) or the reuse flag is flag, then a new package is created
/// </summary>
/// <param name="packageName"></param>
/// <param name="project"></param>
public ISPackage(string packageName, ISProject project, bool reusePackageIfExists = true) : base(packageName, project)
{
AddToProject(packageName, project, reusePackageIfExists);
Project = project;
}
/// <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)
{
}
/// <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)
{
}
internal ISBaseFlatFileConnectionManager(string connectionString, string name, string creationName, ISProject project = null, ISPackage package = null)
: base(connectionString, name, creationName, project, package)
{
}
/// <summary>
/// A constructor that accepts a Package name and parent project.
/// If a package with the same name already exists in the Project, it is associated with the variable on which the constructor is called.
/// If the package does not exist, then a new package is created and added to the project.
/// </summary>
/// <param name="packageName"></param>
/// <param name="project"></param>
public ISEventsProvider(string packageName, ISProject project) : base(packageName, project)
{
}
/// <summary>
/// A constructor that accepts a Package name and parent project.
/// If a package with the same name already exists in the Project, it is associated with the variable on which the constructor is called.
/// If the package does not exist, then a new package is created and added to the project.
/// </summary>
/// <param name="packageName"></param>
/// <param name="project"></param>
public ISEventsProviderAsIDTSSequence(string packageName, ISProject project) : base(packageName, project)
{
}
/// <summary>
/// A constructor that accepts a Package name and parent project.
/// If a package with the same name already exists in the Project, it is associated with the variable on which the constructor is called.
/// If the package does not exist, then a new package is created and added to the project.
/// </summary>
/// <param name="packageName"></param>
/// <param name="project"></param>
public ISExecutable(string packageName, ISProject project)
{
}
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>
/// A constructor that accepts a Package name and parent project.
/// If a package with the same name already exists in the Project, it is associated with the variable on which the constructor is called.
/// If the package does not exist, then a new package is created and added to the project.
/// </summary>
/// <param name="packageName"></param>
/// <param name="project"></param>
public ISContainer(string packageName, ISProject project) : base(packageName, project)
{
}
