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); }