I have a DTS package that I created with the Wizard. If I reenter in
Design mode and enter SQL Server connection 1 and change the User Name
and password and then close. When I click on the connecting line to
Connection 2, it tells me that Login failed for user: UserX. When I look
at the properties for Connection 1, the password is blank as if it
Has anyone seen this? Thanks.