Hi,

I work with Sql Server Business Intelligence Development
I import a DTS coming from SQL 2000 server and the importation work with
succes

Now I want to edit a connection that is in the connection manager
I try to use a Sql Server Authentication and I click the radio button save
Password
I test the connection and the connection succes
I click OK and close the Connection Manager Window

When I try my DTS that use the connection, the connection failed
I open the Connection Manager for that connection and I realize that the
Connection Manager did not save my password even if I click the radio button
Save password

Is that a bug or am I doing something wrong?

If I use the Windows authentication it works well but I would prefer to use
Sql Authentication because when I will release those DTS to my client server
I dont want to have to edit every DTS.

Do you have and idea of how I can get through this problem?

Thanks in advance I have a nice Day!

This is not a bug. It is by design. MS started getting more secure and this
is a side benefit(?).

Since you are using SQL 2005 or 2008 and BIDS, you are using SSIS, not DTS,
dorrect?

Try this: Open a package and look at the package properties pane. look for
an entry "Package Protection Level".


--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"GC" wrote: