Home Forums Data Warehousing Integration Services Calling Windows Environment variable into the Master package in Project Deployment model RE: Calling Windows Environment variable into the Master package in Project Deployment model

  • Hi , I should not use ?

    I have tried the other method as Deployed my project in the SSIS catalog and then created a Environment variable in the SSIS catalog and assigned to a project parameter and this is done through my local server and i am running the Master package by creating the job

    But my requirement is something like on whatever server i am deploying i will configure the windows environment variable and the Master package should consider the Environment variable Server Name in that server and i just i need to execute the Job and not doing anything manually and it should be automatic on any server that i deploy for ..

    So i hope i was able to convey what i require ...if this can be done easily by the way your suggesting ..pls let me know the process and how it can be accomplished easily on other servers too..

    Thanks & Regards,

    Guitar_Player