Problem Note 18287: Macro variable names defined in a generated transformation revert back
to default when job is deployed
Generated transformations allow you to override the default macro
variable names that reference transformation input and output tables.
If you do not override the defaults, these macro variable names are
generated as follows:
_INPUT0 − _INPUTx and _OUTPUT0 − _OUTPUTy, where x is the the number of
input tables − 1 and y is the number of output tables − 1.
In some situations, the macro variable names revert back to their
default values during job deployment and this results in errors because
the transformation code expects the name overrides.
Possible workarounds to this problem are:
- Change the transformation code so it references the default macro
variable names.
- Replace the deployed code file with the contents of the Source window
because this will always contain the name overrides.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Data Integration Studio | Microsoft Windows NT Workstation | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.1 TS1M3 SP3 |
| Microsoft Windows XP Professional | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows 2000 Server | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
| Microsoft Windows 2000 Professional | 3.3 | 4.2 | 9.1 TS1M3 SP3 | 9.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2006-08-31 13:23:15 |
| Date Created: | 2006-08-15 15:18:35 |
