Changing the Mode on Import Set

[Jazz1]

Hello,

         It is about the import mode on Import Set and I have tried and tried as per what some folks have reported but none of it works. For instance I am told you are supposed to create an Import Set after you have created the Import Set Table but the Create Import Set gives me the following :-

The Import Set table is completely greyed out and I have delegated admin role. You can't set the mode through a script option either. The default Import Set for an Import Set Table always defaults to SYNCHRONOUS. I want to load first and then transform. 

My load and transform process is currently running into a "Maximum execution time exceeded" because of the mode which is set at 3600 secs.

Could someone explain in layman steps as to how to go about changing the import mode?

Thanks

[nataliya_b]

how do you create and load your import set table?

if pro grammatically, then you should set have importsettable.sys_import_set =  your importset sysid there, plus you will need to populate row column.

after your could do your transform, transform code shall include your importset with state "loaded"

[Jazz1]

I created the import set table manually. I saw another posting wherein it was stated there is no way to change the mode in a script.

[nataliya_b]

yes, you created importset (sys_import_set) manually to get importset mode = asynchronos,what about staging table with data? how do you create it?

[Jazz1]

The staging table is being loaded through a script step in the IntegrationHub. I did not create the import set manually though. Is there a way to override the mode on the default import set pro grammatically?