Programmatically Changing Connections in DTS

  • I have an ActiveX task containing vbscript that when placed in a DTS package, will set all Connection and DataTransformation (DataPump) information correctly. Additionally, the package appears to work perfectly afterwards.

    The Question:

    Why when I go into the DTS Designer and open a transformation (Black Arrow) between connections - that I get the "Verifying Transformations" dialog with the three radio button options of "Remove Invalid transforamtions", "Change Source/Destination", and "Remove all transformations and redo auto-mapping"?

    It appears that the SourceObjectName and SourceSQLStatements are getting correctly updated as well as the DestinationObjectName, etc.

    Is there a property that is supposed to be set when I modify the source and destination properties in my code to prevent this dialog?

    Thanks a bunch in advance for any assistance

  • quote:


    I have an ActiveX task containing vbscript that when placed in a DTS package, will set all Connection and DataTransformation (DataPump) information correctly. Additionally, the package appears to work perfectly afterwards.

    The Question:

    Why when I go into the DTS Designer and open a transformation (Black Arrow) between connections - that I get the "Verifying Transformations" dialog with the three radio button options of "Remove Invalid transforamtions", "Change Source/Destination", and "Remove all transformations and redo auto-mapping"?

    It appears that the SourceObjectName and SourceSQLStatements are getting correctly updated as well as the DestinationObjectName, etc.

    Is there a property that is supposed to be set when I modify the source and destination properties in my code to prevent this dialog?

    Thanks a bunch in advance for any assistance


    Michael Weiss


    Michael Weiss

  • I don't know if there is a property to set to control the verification of transformations. I do know that the notification with the three options available is a real source of frustration at times...wish I could help more. Have you tried searching anywhere else for an answer? This would be a good question to know the solution to...

    Thank you,

    Michael

    Michael Weiss


    Michael Weiss

  • Was a solution ever found for this?? I've been trying to do that same thing for awhile now! Any information on how to Dynamically create Transformations through a script would be most helpful to me! Thanks..

  • Have you tried creating a transformation then saving the package as a visual basic file, then opening the vb project and looking through the code that was generated? This is a good way to familiarize yourself with the syntax and object model(s)...

    hth,

    Michael

    Michael Weiss


    Michael Weiss

  • When you are at design mode and try to view properties DTS verifies the datapump task properties and when they are invalid (as at the moment of checking them) displays that dialog box. You can still edit the properties in the disconnected edit mode.

    Why do you need to check/change the properties of the datapump task - you say it works fine.

    As the last resort - run manually your ActiveX task in design mode - it will set your connection etc properties properly and you will be able to view your datapump task in DTS Designer.

    Regards

    Tom

Viewing 6 posts - 1 through 5 (of 5 total)

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