Post reply

SQL Server jobs to use file server name variable?

  • October 3, 2008 at 6:35 am

    #125045

    I am using SQL Server 2005 to run scheduled jobs that include SSIS packages. Because I have so many jobs, when I change the name of the server that has the files (SSIS package or input files), I do not want to have to edit the jobs individually to update the path to the files.

    Is there a way to store the server name or full path in a certain table in SQL Server so that I can make the change in one place and have some variable in the jobs use this as a reference at run time?

    Any input is highly appreciated.

    MGA

  • October 3, 2008 at 12:02 pm

    #880646

    That is exacty what I am doing.

    I store server names in a table in a database and then dynamic SQL Script that uses OPENROWSET is generated to use the names, connects to the servers and get the backup information.

    SSIS Packages do have package variables too. For jobs you can use Master /Target setup

    Regards,Yelena Varsha

  • October 3, 2008 at 9:54 pm

    #880789

    Thanks much for the answer. I will check it out.

    MGA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply