• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

SSIS Microsoft Server 2005 not saving password

First time poster hope someone can help

I am trying to connect using Sybase Adaptive Server Anywhere Provider 9.0 to my data warehouse to copy data. I choose Import and go to the wizard.

Everything works fine until I try to run the package or save it then it tells me it cannot connect to the source. I've tried every setting I can find (including "Allow saving password") VERY FUNNY MICROSOFT!!! anyway, it will not save the password to connect to the data warehouse nor will it prompt me for it the wizard; it just keeps setting itself to "Use Windows NT Intergrated security".

And while where at it could some please tell Microsoft to drop the NT already
2 Solutions
ValentinoVBI ConsultantCommented:
You should set the ProtectionLevel property of your package to "DontSaveSensitive", and then configure the passwords using Package Configuration.  If you don't want to use Package Config, another option is to pass the correct parameter along with the dtexec command.

Protection Levels: http://msdn.microsoft.com/en-us/library/ms141747.aspx
Package Config: http://msdn.microsoft.com/en-us/library/ms141682.aspx
dtexec utility: http://msdn.microsoft.com/en-us/library/ms162810.aspx
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now