"Spike" <jeroenaNOSPAM@hotmail.com> wrote in message
news:bvgfcm$50$1@reader08.wxs.nl...
> Hi,
>
> What's the best way to have a single point of config for my databasenames?
I
> use the dynamic property task in all packages to set the UDL path of a
> database connection with an environment variable. This works fine when I
run
> it manually (because I set the variables manually as well), but when I
> schedule the package the SQL Agent it can't find the environment variable.
>
> SQL Server Agent runs under a SQLAdmin domain account.
>
> Executed as user: MYDOMAIN\SQLAdmin. ...tus_db.udl C:\WINNT\system32>SET
> DWH_UDL_CDWH_DB=c:\datawarehouse\_udl\cdwh_db.udl C:\WINNT\system32>SET
> DWH_UDL_CONTROL_DB=c:\datawarehouse\_udl\control_db.udl
> C:\WINNT\system32>SET
> DWH_UDL_IDS_ARTUS_DB=c:\datawarehouse\_udl\IDS_Artus_db.udlDTSRun:
> Loading... DTSRun: Executing... DTSRun OnStart:
> DTSStep_DTSCreateProcessTask_4 DTSRun OnFinish:
> DTSStep_DTSCreateProcessTask_4 DTSRun OnStart:
> DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
> DTSStep_DTSExecutePackageTask_1, Error = -2147220489 (800403F7) Error
> string: DTSStep_DTSDynamicPropertiesTask_1: Environment variable
> 'DWH_UDL_CONTROL_DB' not found. Error source: Dynamic Properties Task Help
> file: Help context: 0 Error Detail Records: Error: 0 (0); Provider Error:
0
> (0) Error string: Environment variable 'DWH_UDL_CONTROL_DB' not found.
Error
> source: Dynamic Properties Task Help file: ... Process Exit Code 0. The
step
> succeeded.
>
> Thnx.
>
>