Hi Guys,

I'm attempting to specify transformation information manually. I have a SQL source connection and a File Destinaton. All I want to do is specify different column from the same table dynamically. If global variable input is "A" then export columns Col1, Col2 and Col4, if the global variable is "B" then export columns Col1, Col2, Col5, Col7.

Is it possible to do something like

With MyTransformation
.Clear
.SourceColumns.Add(1).Value = "Col1"
.DestinationColumns.Add(1).Value = "Col1"
End With

Thanks in advance...