/// <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) { }