January 10, 2008 at 7:38 am
I am developing an app which interacts with SS2000 table that are updated nightly via a DTS job from an RMS file system on a VMS box.
The step that I would like to bypass is rebuilding the DTS job anytime I add a new column to one of the tables. I tried just editing the SQL in the DTS package and it does not recognize the new column(s).
Is there anyway to do this so that I don't have to recreate the DTS job each time I map a new column to be updated?
TIA
January 10, 2008 at 2:53 pm
anytime I add a new column to one of the tables.
Does it happen often?
Man, you should rethink you approach to database design.
Changing schema must be a big event everybody is afraid of which hopefully never happens in the project lifetime.
_____________
Code for TallyGenerator
January 10, 2008 at 2:59 pm
It doesn't happen too often but it happens outside my area of control....
When the VMS application programmer adds a feature to the legacy app (written in DEC basic running on an Alpha box) it will add/change a location (column) in the RMS filesystem which will then force me to add a column in the mapped table which results in the change to the DTS package.
Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply