Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jeroena
Yak Posting Veteran
76 Posts |
 Posted - 2004-01-29 : 05:33:20
|
| 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 says: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. |
|
|
|
|
|
Scheduling and environment variables