SPD Server Table Loader Transformation autogenerates a libname statement

[Criptic]

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

[LinusH · Accepted solution]

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)?

[Criptic]

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