SAS DI - "Load Time" column in Table Loader

[filippo_kow]

 Hi guys,

I am a little bit confused with usage of one of the option in Table Loader transformation.

In Options->Additional Loader Options there is an option to select load time column. In jobs that I am currently changing there is already one column selected. However, I would like to leave it empty (I am appending data from old environment to the new one and I would like not to overwrite this column). And here comes my question. For some jobs, I can simply press 'Reset' button and this column is empty, but for some other jobs after pressing 'Reset' nothing happens (this column is still filled). As I see, the Table Loader looks the same for all jobs (I mean the same options, load techniques and so on). Does anyone have an idea what should I do to leave this option empty?

 Thanks in advance!
 Filip

[Patrick]

I can't answer your concrete question but just as a thought:

If this is about data migration then I wouldn't use the existing load jobs at all but I would copy the data from the old to the new environment and then use Proc Datasets/Copy to re-create the tables in the target location with the settings like encoding of the target location and all the indexes and constraints that were already defined in source.

IF you want to use DIS for this then you could write custom code and call it via a loop transformation with a control table that contains table name, source path and target path as data for parameter passing.