>-----Original Message-----
>Hi,
>
>Acutally I intend to modify the design instead of
running it. I think one
>way to avoid to make ths happen is to add a password to
a dts, how can I do
>it?
>
>In Enterprise manager, Open the package and go to
Package menu then select
>"SAVE AS" option, there you can set the Owner and User
Password.
>This will ensure that package wont execute in double
click.
>
>Another thing when I made the mistake, I hit cancel,
does it cancel all the
>processes the dts has already run?
>
>This may not rollback all the processes. This depends on
your DTS package
>design. Say you have a package to
>1. load data into a table from text file
>2. From the table select only the distinct department to
a master table and
>you press cancel during this step
>3. This case you first step will be successful and the
second one might
>rollback.
>
>Thanks
>Hari
>MCDBA
>
>
>
>"Ann" <anonymous@discussions.microsoft.com> wrote in
message
>news:5F0F5C46-FA6F-4817-9A3F-
B978450DA353@microsoft.com...
>> I have some dts set up in the SQL server. Sometimes I
found I can easily
>make a mistake by accidently double click a dts package
and make it run
>immediately.
>>
>> Acutally I intend to modify the design instead of
running it. I think one
>way to avoid to make ths happen is to add a password to
a dts, how can I do
>it?
>>
>> Another thing when I made the mistake, I hit cancel,
does it cancel all
>the processes the dts has already run?
>>
>> Thanks
>>
>
>
>.