protected virtual void AddTableOrViewCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
{
ComponentWrapper.SetComponentProperty("OpenRowset", TableOrViewName);
ComponentWrapper.SetComponentProperty("DefaultCodePage", 65001);
ComponentWrapper.SetComponentProperty("CommandTimeout", 0);
ComponentWrapper.SetComponentProperty("AlwaysUseDefaultCodePage", false);
}
internal void SetComponentWrapperProperties(Pipe.CManagedComponentWrapper ComponentWrapper)
{
switch (DataAccessMode)
{
case DataAccessMode.SqlCommand: AddSqlCommand(ComponentWrapper); break;
case DataAccessMode.TableOrView: AddTableOrViewCommand(ComponentWrapper); break;
}
}
protected virtual void AddComponent(Pipe.MainPipe dataFlowTask, string componentClassID)
{
Component = dataFlowTask.ComponentMetaDataCollection.New();
Component.ComponentClassID = componentClassID;
ComponentWrapper = Component.Instantiate();
ComponentWrapper.ProvideComponentProperties();
Component.Name = Name;
Component.Description = Description;
}
protected override void AddTableOrViewCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
{
ComponentWrapper.SetComponentProperty("AccessMode", OLEDBDestinationAccessMode.OpenRowsetUsingFastload);
base.AddTableOrViewCommand(ComponentWrapper);
if (HasFastLoadOptions)
{
ComponentWrapper.SetComponentProperty("FastLoadOptions", string.Join(",", FastLoadOptions.ToArray()));
}
ComponentWrapper.SetComponentProperty("FastLoadKeepIdentity", false);
ComponentWrapper.SetComponentProperty("FastLoadKeepNulls", false);
ComponentWrapper.SetComponentProperty("FastLoadMaxInsertCommitSize", 2147483647);
}
protected override void AddTableOrViewCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
{
ComponentWrapper.SetComponentProperty("AccessMode", OLEDBSourceAccessMode.OpenRowset);
base.AddTableOrViewCommand(ComponentWrapper);
}
protected virtual void AddSqlCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
{
ComponentWrapper.SetComponentProperty("SqlCommand", SqlCommand);
ComponentWrapper.SetComponentProperty("AccessMode", 2);
}
