SSIS动态列映射

【文件属性】：

文件名称：SSIS动态列映射

文件大小：7KB

文件格式：TXT

更新时间：2016-02-01 08:30:24

SSIS

SSIS动态列映射 Public Sub Main() Try ' Create a package and add a Data Flow task. Dim package As Microsoft.SqlServer.Dts.Runtime.Package = New Microsoft.SqlServer.Dts.Runtime.Package() package.Name = "From" & _ Replace(Replace(Replace(Dts.Variables("SourceTable").Value.ToString, ".", ""), "]", ""), "[", "") & "To" & _ Replace(Replace(Replace(Dts.Variables("DestinationTable").Value.ToString, ".", ""), "]", ""), "[", "") package.ProtectionLevel = DTSProtectionLevel.DontSaveSensitive