Hi,
I created a DTS package with password. I would like to
remove that password option. How do I make this change ?
I don't want to drop and create this pkg since it's a lot
of work for me !!
TIA
Mohan

You don't need to drop it rather youneed to

Open | Save As.

If you want it saved back as the original name then you need to drop the
original and then

Open | Save As

Again on the package you just did it on.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mo" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I'd do a "save as" and give the dts a "-1" or "ver1"
indicator. Delete the original then rename the "-1"
or "ver1" DTS to the original name.

Sounds good to me.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


<anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks guys. It worked great !!!
Mo