Post reply

Accessing meta data for dts transformation object

  • August 1, 2006 at 7:21 am

    #67610

    I want to access meta data for source/destination columns in a DTS transform. I believe these are proberties of the DTSTransforamtion Object.... but how can I instantiate / access this object?

    Thanks.

  • August 2, 2006 at 7:15 am

    #652797

    How are you attempting to access this information? C+? VB? Internally to the package?

    If you are attempting to retrieve information about the source columns for a transform within a DTS package using VBS, you can use the following as an example. Put this code into an ActiveX Script task within your package and execute the task. It will present message boxes with the info about the source columns for the first transform of the specific transform task.

    Function Main()
 Set objPackage = DTSGlobalVariables.Parent
 Set objTask = objPackage.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask
 Set objTransform = objTask.Transformations(1)
 Set objSC = objTransform.SourceColumns
     For each sc in objSC
  Set arrColProp = sc.Properties
  For each arr in arrColProp
   msgbox arr.name & ": " & arr
  Next
     Next
     Main = DTSStepScriptResult_ExecuteTask
End Function

  • August 2, 2006 at 1:11 pm

    #652922

    Thanks, much. Just what I was looking for... 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply