SAS DI - "Load Time" column in Table Loader

filippo_kow — Sat, 16 Mar 2024 10:44:34 GMT

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

Re: SAS DI - "Load Time" column in Table Loader

Patrick — Sun, 17 Mar 2024 03:40:55 GMT

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.

topic SAS DI - "Load Time" column in Table Loader in Developers

SAS DI - "Load Time" column in Table Loader

Re: SAS DI - "Load Time" column in Table Loader