August 7, 2018 at 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?
August 7, 2018 at 12:57 pm
Weegee2017 - Tuesday, August 7, 2018 8:42 AMHi thereI 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