Esempi in C# (CSharp) per Microsoft.SqlServer.Dts.Pipeline.Wrapper CManagedComponentWrapper.SetComponentProperty

Esempio n. 1

File: OLEDBProperties.cs Progetto: lmm713281/programmingSSIS

        protected virtual void AddTableOrViewCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
        {
            ComponentWrapper.SetComponentProperty("OpenRowset", TableOrViewName);

            ComponentWrapper.SetComponentProperty("DefaultCodePage", 65001);
            ComponentWrapper.SetComponentProperty("CommandTimeout", 0);
            ComponentWrapper.SetComponentProperty("AlwaysUseDefaultCodePage", false);
        }

Esempio n. 2

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

Esempio n. 3

File: OLEDBSourceProperties.cs Progetto: lmm713281/programmingSSIS

 protected override void AddTableOrViewCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
 {
     ComponentWrapper.SetComponentProperty("AccessMode", OLEDBSourceAccessMode.OpenRowset);
     base.AddTableOrViewCommand(ComponentWrapper);
 }

Esempio n. 4

File: OLEDBProperties.cs Progetto: lmm713281/programmingSSIS

 protected virtual void AddSqlCommand(Pipe.CManagedComponentWrapper ComponentWrapper)
 {
     ComponentWrapper.SetComponentProperty("SqlCommand", SqlCommand);
     ComponentWrapper.SetComponentProperty("AccessMode", 2);
 }