Exception File with a Global Variable 1

[TeamGD]

I have numerous Transform Data Tasks in which I’m logging exceptions to files that I’ve set in the Options tab. All exception files are located on the same server and folder structure (currently it is \\flafile001\datawarehouse$\DatamartErrorLogs\). This folder structure has changed several times, so each time I must edit every Transform Data Tasks and enter the new folder structure into the Options tab.

How can this be set just once?

I’ve played with global variables, but I’ve been unable to work out how to refer to a global variable in the Exception File on the Options tab.

Cheers

 

[JohnDTampaBay]

You can't refer to the global variable for the Exceptions filename directly. You can use a Dynamic Properties task to set the ExceptionFileName property of the Data Pump task using a global variable. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)

 

[TeamGD]

Thanks John ... it has been a while ... but I'm back onto this & your solution is what I want

Cheers

Greg