topic Re: SPD Server Table Loader Transformation autogenerates a libname statement in SAS Data Management

SPD Server Table Loader Transformation autogenerates a libname statement

Criptic — Mon, 07 Jan 2019 13:02:34 GMT

Hello,

When I transport a job from one environment to the other in DI Studio the SPD Server Table Loader Transformation in the environment I imported the job into autogenerates a libname statement which is just wrong and throws an ERROR - I could of course comment the statement out but there seems to be an option set in one environment which enables this autogeneration of the libname statement - anybody an idea which option I have to set?

Kind Regards

Criptic

Re: SPD Server Table Loader Transformation autogenerates a libname statement

LinusH — Mon, 07 Jan 2019 14:07:04 GMT

First step is to compare how the libnames are defined in respective environment.

Also, be sure when you import the job that librefs are mapped to the correct one in the target environment.

Put the generated libname statemnts side by side, determine the difference, and find the setting in metadata.

Or is it even that you don't get a libame in the source environment (pre-assigned)?

Re: SPD Server Table Loader Transformation autogenerates a libname statement

Criptic — Tue, 08 Jan 2019 07:25:55 GMT

Pre-Assigned was the right keyword here for me. Somehow I forgot to set that option in one environment. Thank you!