【文件属性】：
文件名称：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
网友评论
- VB 代码， 没用上。