Any ideas on how I could handle a DTS import situation
where my source table (actually Unix/Informix) will
actually vary a bit from import to import (extra field or
2 or maybe even minus a field or 2). The only thing I can
bank on is the source table name.
In other words, is it possible to somehow bypass
the "destination" tab in the Designer and have DTS create
the destination table on the fly?
Here's my intention:
-->load Unix/Informix table "as is" (staging table)
-->using syscolumns, compare table structure with prior
-->if same as prior run, append to production table
-->if not, then error handle, email notify, etc.
Thanks in advance for any suggestions,