Unable to save password in SSIS package on Visual Studio 2015

  • Hi there

    I am trying to run a SSIS package in a Visual Studio Solution on 2015

    However everytime i enter the password, test connection is successful...then the password isnt remembered

    Is there somthing that i need to set within the project or at the package level?

  • Weegee2017 - Tuesday, August 7, 2018 8:42 AM

    Hi there

    I am trying to run a SSIS package in a Visual Studio Solution on 2015

    However everytime i enter the password, test connection is successful...then the password isnt remembered

    Is there somthing that i need to set within the project or at the package level?

    First, saving a password like that is a TERRIBLE, HORRIBLE, NO GOOD, VERY  BAD idea.   It puts the keys to everything that id has access to right where a hacker might easily get their hands on it, in plain text, right there in the package dtsx file.   As to the problem itself, it's probably that a project level setting known as "Don't Save Sensitive" has been set, which keeps that bad idea from happening as long as that setting remains set.   Do NOT undo that setting.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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