faquue
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.