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 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 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;
}
public abstract IDTSComponentMetaData100 AddDestAdapter(IDTSPipeline100 pipeline, ConnectionManager destConnMgr, out IDTSDesigntimeComponent100 destDesignTimeComp);
public abstract IDTSComponentMetaData100 AddSourceAdapter(IDTSPipeline100 pipeline, ConnectionManager srcConnMgr);
internal BipsProxyIDTSPipeline100(IDTSPipeline100 innerObject)
{
_innerObject = innerObject;
}
