public override IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp) { if (String.IsNullOrEmpty(quotedTableName)) { throw new ArgumentException("Destination table name is empty"); } IDTSComponentMetaData100 destComp = pipeline.ComponentMetaDataCollection.New(); destComp.ComponentClassID = OLEDB_DEST_GUID; destComp.ValidateExternalMetadata = true; destDesignTimeComp = destComp.Instantiate(); destDesignTimeComp.ProvideComponentProperties(); destComp.Name = "OleDB Destination - Sql Server"; destDesignTimeComp.SetComponentProperty("AccessMode", 0); destDesignTimeComp.SetComponentProperty("OpenRowset", quotedTableName); // set connection destComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(destConnMgr); destComp.RuntimeConnectionCollection[0].ConnectionManagerID = destConnMgr.ID; // get metadata destDesignTimeComp.AcquireConnections(null); destDesignTimeComp.ReinitializeMetaData(); destDesignTimeComp.ReleaseConnections(); extCols = destComp.InputCollection[0].ExternalMetadataColumnCollection; return(destComp); }
public override IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp) { if (String.IsNullOrEmpty(quotedTableName)) { throw new ArgumentException("Destination table name is empty"); } IDTSComponentMetaData100 destComp = pipeline.ComponentMetaDataCollection.New(); destComp.ComponentClassID = OLEDB_DEST_GUID; destComp.ValidateExternalMetadata = true; destDesignTimeComp = destComp.Instantiate(); destDesignTimeComp.ProvideComponentProperties(); destComp.Name = "OleDB Destination - Sql Server"; destDesignTimeComp.SetComponentProperty("AccessMode", 0); destDesignTimeComp.SetComponentProperty("OpenRowset", quotedTableName); // set connection destComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(destConnMgr); destComp.RuntimeConnectionCollection[0].ConnectionManagerID = destConnMgr.ID; // get metadata destDesignTimeComp.AcquireConnections(null); destDesignTimeComp.ReinitializeMetaData(); destDesignTimeComp.ReleaseConnections(); extCols = destComp.InputCollection[0].ExternalMetadataColumnCollection; return destComp; }
/// <summary> /// Adds a component to a data flow /// </summary> /// <param name="dataFlowMainPipe"></param> /// <param name="name"></param> /// <param name="componentName"></param> /// <returns></returns> public static IDTSComponentMetaData100 AddComponentToDataFlow(this IDTSPipeline100 dataFlowMainPipe, string name, string componentName) { if (dataFlowMainPipe != null) { //create the component var componentMetaData = dataFlowMainPipe.ComponentMetaDataCollection.New(); componentMetaData.Name = name; componentMetaData.ComponentClassID = componentName; return(componentMetaData); } throw new SsisScripterException("The IDTSPipeline100 object passed to this method was null"); }
public override IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp) { IDTSComponentMetaData100 destComp = pipeline.ComponentMetaDataCollection.New(); destComp.ComponentClassID = FLATFILE_DEST_GUID; destComp.ValidateExternalMetadata = true; destDesignTimeComp = destComp.Instantiate(); destDesignTimeComp.ProvideComponentProperties(); destComp.Name = "Flat File Destination"; destDesignTimeComp.SetComponentProperty("Overwrite", true); // set connection destComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(destConnMgr); destComp.RuntimeConnectionCollection[0].ConnectionManagerID = destConnMgr.ID; // get metadata destDesignTimeComp.AcquireConnections(null); destDesignTimeComp.ReinitializeMetaData(); destDesignTimeComp.ReleaseConnections(); return(destComp); }
public override IDTSComponentMetaData100 AddSourceAdapter(IDTSPipeline100 pipeline, ConnectionManager srcConnMgr) { IDTSComponentMetaData100 srcComp = pipeline.ComponentMetaDataCollection.New(); srcComp.ComponentClassID = FLATFILE_SRC_GUID; srcComp.ValidateExternalMetadata = true; IDTSDesigntimeComponent100 srcDesignTimeComp = srcComp.Instantiate(); srcDesignTimeComp.ProvideComponentProperties(); srcComp.Name = "Flat File Source"; // set connection srcComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(srcConnMgr); srcComp.RuntimeConnectionCollection[0].ConnectionManagerID = srcConnMgr.ID; // get metadata srcDesignTimeComp.AcquireConnections(null); srcDesignTimeComp.ReinitializeMetaData(); srcDesignTimeComp.ReleaseConnections(); return(srcComp); }
public void ConstructPackage(bool createNew) { // Create SSIS package package = new Microsoft.SqlServer.Dts.Runtime.Package(); // Add DataFlow task dataFlowTask = package.Executables.Add("STOCK:PipelineTask"); TaskHost taskhost = dataFlowTask as TaskHost; taskhost.Name = "Data Flow Task"; pipeline = taskhost.InnerObject as MainPipe; // Add source connection manager and adapter if (SourceProvider == null) { throw new InvalidOperationException("Empty source provider."); } else { srcConnMgr = SourceProvider.AddConnectionManager(package); srcComp = SourceProvider.AddSourceAdapter(pipeline, srcConnMgr); } // Add destination connection manager and adapter, create new table if asked to. if (DestProvider == null) { throw new InvalidOperationException("Empty destination provider."); } else { if (createNew) { DestProvider.CreateDestination(srcComp.OutputCollection[0].OutputColumnCollection); } destConnMgr = DestProvider.AddConnectionManager(package); destComp = DestProvider.AddDestAdapter(pipeline, destConnMgr, out destDesignTimeComp); } }
public override IDTSComponentMetaData100 AddSourceAdapter(IDTSPipeline100 pipeline, ConnectionManager srcConnMgr) { IDTSComponentMetaData100 srcComp = pipeline.ComponentMetaDataCollection.New(); srcComp.ComponentClassID = EXCEL_SRC_GUID; srcComp.ValidateExternalMetadata = true; IDTSDesigntimeComponent100 srcDesignTimeComp = srcComp.Instantiate(); srcDesignTimeComp.ProvideComponentProperties(); srcComp.Name = "OleDB Source - Excel"; srcDesignTimeComp.SetComponentProperty("AccessMode", 0); // OleDb provider does not recognize OpenRowSet name quoted with ` srcDesignTimeComp.SetComponentProperty("OpenRowset", UnquotedSheetName); // set connection srcComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(srcConnMgr); srcComp.RuntimeConnectionCollection[0].ConnectionManagerID = srcConnMgr.ID; // get metadata srcDesignTimeComp.AcquireConnections(null); srcDesignTimeComp.ReinitializeMetaData(); srcDesignTimeComp.ReleaseConnections(); extCols = srcComp.OutputCollection[0].ExternalMetadataColumnCollection; return srcComp; }
public override IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp) { IDTSComponentMetaData100 destComp = pipeline.ComponentMetaDataCollection.New(); destComp.ComponentClassID = EXCEL_DEST_GUID; destComp.ValidateExternalMetadata = true; destDesignTimeComp = destComp.Instantiate(); destDesignTimeComp.ProvideComponentProperties(); destComp.Name = "OleDB Destination - Excel"; destDesignTimeComp.SetComponentProperty("AccessMode", 0); // OleDb provider does not recognize OpenRowSet name quoted with ` destDesignTimeComp.SetComponentProperty("OpenRowset", UnquotedSheetName); // set connection destComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(destConnMgr); destComp.RuntimeConnectionCollection[0].ConnectionManagerID = destConnMgr.ID; // get metadata destDesignTimeComp.AcquireConnections(null); destDesignTimeComp.ReinitializeMetaData(); destDesignTimeComp.ReleaseConnections(); extCols = destComp.InputCollection[0].ExternalMetadataColumnCollection; return(destComp); }
public abstract IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp);
public abstract IDTSComponentMetaData100 AddSourceAdapter(IDTSPipeline100 pipeline, ConnectionManager srcConnMgr);
public override IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp) { IDTSComponentMetaData100 destComp = pipeline.ComponentMetaDataCollection.New(); destComp.ComponentClassID = FLATFILE_DEST_GUID; destComp.ValidateExternalMetadata = true; destDesignTimeComp = destComp.Instantiate(); destDesignTimeComp.ProvideComponentProperties(); destComp.Name = "Flat File Destination"; destDesignTimeComp.SetComponentProperty("Overwrite", true); // set connection destComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(destConnMgr); destComp.RuntimeConnectionCollection[0].ConnectionManagerID = destConnMgr.ID; // get metadata destDesignTimeComp.AcquireConnections(null); destDesignTimeComp.ReinitializeMetaData(); destDesignTimeComp.ReleaseConnections(); return destComp; }
public override IDTSComponentMetaData100 AddSourceAdapter(IDTSPipeline100 pipeline, ConnectionManager srcConnMgr) { IDTSComponentMetaData100 srcComp = pipeline.ComponentMetaDataCollection.New(); srcComp.ComponentClassID = FLATFILE_SRC_GUID; srcComp.ValidateExternalMetadata = true; IDTSDesigntimeComponent100 srcDesignTimeComp = srcComp.Instantiate(); srcDesignTimeComp.ProvideComponentProperties(); srcComp.Name = "Flat File Source"; // set connection srcComp.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.GetExtendedInterface(srcConnMgr); srcComp.RuntimeConnectionCollection[0].ConnectionManagerID = srcConnMgr.ID; // get metadata srcDesignTimeComp.AcquireConnections(null); srcDesignTimeComp.ReinitializeMetaData(); srcDesignTimeComp.ReleaseConnections(); return srcComp; }
internal BipsProxyIDTSPipeline100(IDTSPipeline100 innerObject) { _innerObject = innerObject; }