SSIS Microsoft Server 2005 not saving password
Posted on 2011-09-07
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