Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    Unanswered: Pulling registry settings into SSIS package

    Does anyone know of a way to pull registry settings into a variable.
    I would like to build a connection string for the database connections by pulling data out of the registry.
    All settings in this environment are kept there and would like to have a way of getting them out.
    If anyone can point me in the right direction that would be greatly appreciated.

    thanks,
    Jonathan

  2. #2
    Join Date
    Aug 2008
    Posts
    4
    Use xp_regread (this is SQL extended SP)

  3. #3
    Join Date
    Jun 2006
    Location
    DC
    Posts
    123

    thanks

    thanks that helps a lot and would have made it easier...
    I ended up using vb.net to pull the registry values using the script task.....
    this will be another way of doing it in the future.. if the other option isn't available....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •