July 14, 2009 at 7:13 am
For my SSIS dtsConfig file location, I have created 2 system environment variables:
Name: SSIS_Config_Dir
Value: C:\Scripts\SSIS\ConfigFiles
Name: SSIS_Config
Value: %SSIS_Config_Dir%\SSIS_Config01.dtsConfig
I'd like to omit the use of C: in the 1st variable VALUE above. Should I create a SHARE on this directory path (eg: SSISConfig) then set the value as \\myMachine\SSISConfig ??
I want to get away from hardcoding the drive letter..
July 14, 2009 at 7:36 am
You could replace the C: with %SystemDrive% which on virtually every system is C:
I'm not a fan of the UNC path since it would require you to think about security of the share.
CEWII
July 14, 2009 at 8:09 am
Elliott - thx for the quick reply... question -- our "system drive" varies from Dev, to QA, to Prod (in Dev it's C: -- In QA & Prod it's D: where we house our dtsConfig file directory... )
If I do use your suggestion: "You could replace the C: with %SystemDrive% which on virtually every system is C:"
Would I create a 3rd variable called:
Name: SystemDrive
Value: C:
then would I need to change my next system environment variable
from:
Name: SSIS_Config_Dir
Value: C:\Scripts\SSIS\ConfigFiles
to:
Name: SSIS_Config_Dir
Value: %SystemDrive%\Scripts\SSIS\ConfigFiles
and leave the 3rd variable as:
Name: SSIS_Config
Value: %SSIS_Config_Dir%\SSIS_Config01.dtsConfig
July 14, 2009 at 12:51 pm
No, that one is built in..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply