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
faquueAsked:
Who is Participating?
 
ValentinoVConnect With a Mentor BI 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
0
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.

All Courses

From novice to tech pro — start learning today.