SSIS for automatically creating linked servers

• John Reddy

  Ten Centuries

  Points: 1250

  More actions

  October 7, 2011 at 3:59 pm

  #260128

  I am attempting to use SSIS in order to automate a very cumbersome process that we are currently using in our production environment.

  Due to audit concerns, we are not supposed to handle any sorts of passwords for any of the linked servers that we use on our production box.

  The process of getting the password is through a command line as following:

  pwecho <server_name> <user_id>

  When the above command is run from a command prompt, a password is returned.

  Currently, this process is handled in a Perl module which is darn time consuming.

  I am trying to replace the module with SSIS to be able to create a dynamic package that can accept a server name and a user id as input, get the password using an execute process task which uses the cmd.exe, store it in an package variable , pass it as input to an execute sql task which creates the linked server using server_name, user_id and the password from the variable.

  This is a long shot but if works can save a ton of time for us.

  Please help.

• John Reddy

  Ten Centuries

  Points: 1250

  More actions

  October 11, 2011 at 3:54 pm

  #1393187

  I was hoping any of the folks to put in some suggestions for my request.

  Any ideas fellas?

  Any sort of help would be much appreciated.

  Thanks 🙂