-
DTS Transform Data Task - Specifying Transpormation Manually
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|