August 15, 2002 at 4:39 pm
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
August 19, 2002 at 9:27 am
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
August 19, 2002 at 9:31 am
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
December 24, 2002 at 12:04 pm
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..
December 24, 2002 at 4:46 pm
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
December 29, 2002 at 7:33 pm
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