DTS permission

I created a DTS package to extract data to a text file.
I want to create a login for a user who should be able ONLY to run this DTS. I don't want to give him/her any access to any database .
Is that possible?
Thanks in advance
GiorgioWithout permission on database user cannot complete the execution of DTS package.|||I find out a workaround:

1) I created a user that has permission only on the sample DB Northwind.

2) The DTS package is protected by "DTS Owner password" and DTS User password

3) The "Connection" in the DTS package has inside a username and password that has acess to the appropriate DB.

With this workaround I obtained that:

1) The user has access only to the Northwind DB
2) The user can run only the DTS package (because is protected with DTS User password).

Thanks anyway to everyone who replied to me!|||Then my reply was intended to light when you said no permission to any database.

DTS PACKAGE OWNERSHIP CHANGE

Can someone please tell me how to easily change the
ownership of a DTS package from the person who created
them to any other login on the server? Thank you.
RandaIn message <1f9501c3e103$6464b960$a301280a@.phx.gbl>, Randa
<anonymous@.discussions.microsoft.com> writes

quote:

---

>It worked just fine and I really appreciate. However, I
>was hoping to do several at a time, I tried it with the IN
>operator and it didn't work - I had an "Incorrect syntax
>near the keyword 'in'" Is there a way of doing more than
>one at a time? Thank you
>Here is my script:
>Exec sp_reassign_dtspackageowner
>@.name in ('NewaPackDB','clientDB'),
>@.id in ('C2C1BBD2-73...','C2C1BBD2-73...'),
>@.newloginname = 'BA\adm'
>

---

There is a script here that does this, but please read the limitations
of this. It is only temporary as it doesn't change the owner in the
underlying package object.
Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

DTS PACKAGE OWNERSHIP CHANGE

Can someone please tell me how to easily change the
ownership of a DTS package from the person who created
them to any other login on the server? Thank you.
RandaIn the msdb database there is stored procedure named
sp_reassign_dtspackageowner that will do the trick. Here's
some sample syntax:
msdb..sp_reassign_dtspackageowner
@.name = 'Package Name',
@.id = 'FF18ACDD-3FBF-48FF-8E1D-0CE4038D5EE4',
@.newloginname = 'sa'
You can obtain the package ID (@.id) from the
msdb..sysdtspackages table (ID column).
EXAMPLE:
First get the id:
Select id from dbo.sysdtspackages
where name = 'MYDTSPACKAGE'
GO
Adjust the syntax
Exec sp_reassign_dtspackageowner
@.name = 'MYDTSPACKAGE',
@.id = 'D72333A2-7DED-11D4-BF04-00B0D057DBE4',
@.newloginname = 'Userid'
Hope it helps......
>--Original Message--
>Can someone please tell me how to easily change the
>ownership of a DTS package from the person who created
>them to any other login on the server? Thank you.
>Randa
>.
>|||It worked just fine and I really appreciate. However, I
was hoping to do several at a time, I tried it with the IN
operator and it didn't work - I had an "Incorrect syntax
near the keyword 'in'" Is there a way of doing more than
one at a time? Thank you
Here is my script:
Exec sp_reassign_dtspackageowner
@.name in ('NewaPackDB','clientDB'),
@.id in ('C2C1BBD2-73...','C2C1BBD2-73...'),
@.newloginname = 'BA\adm'
>--Original Message--
>In the msdb database there is stored procedure named
>sp_reassign_dtspackageowner that will do the trick.
Here's
>some sample syntax:
>msdb..sp_reassign_dtspackageowner
>@.name = 'Package Name',
>@.id = 'FF18ACDD-3FBF-48FF-8E1D-0CE4038D5EE4',
>@.newloginname = 'sa'
>You can obtain the package ID (@.id) from the
>msdb..sysdtspackages table (ID column).
>
>EXAMPLE:
>First get the id:
>Select id from dbo.sysdtspackages
>where name = 'MYDTSPACKAGE'
>GO
>Adjust the syntax
>Exec sp_reassign_dtspackageowner
>@.name = 'MYDTSPACKAGE',
>@.id = 'D72333A2-7DED-11D4-BF04-00B0D057DBE4',
>@.newloginname = 'Userid'
>
>Hope it helps......
>
>>--Original Message--
>>Can someone please tell me how to easily change the
>>ownership of a DTS package from the person who created
>>them to any other login on the server? Thank you.
>>Randa
>>.
>.
>|||In message <1f9501c3e103$6464b960$a301280a@.phx.gbl>, Randa
<anonymous@.discussions.microsoft.com> writes
>It worked just fine and I really appreciate. However, I
>was hoping to do several at a time, I tried it with the IN
>operator and it didn't work - I had an "Incorrect syntax
>near the keyword 'in'" Is there a way of doing more than
>one at a time? Thank you
>Here is my script:
>Exec sp_reassign_dtspackageowner
>@.name in ('NewaPackDB','clientDB'),
>@.id in ('C2C1BBD2-73...','C2C1BBD2-73...'),
>@.newloginname = 'BA\adm'
>
There is a script here that does this, but please read the limitations
of this. It is only temporary as it doesn't change the owner in the
underlying package object.
Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

DTS Package Error: Login failed for user sa

I am trying to edit a DTS package which is a transfer of data between two tables (connections)

i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.

Login failed for user 'sa'

i am running enterprise manager on the server itself so i shouldn't have any connection issues.

if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:

' Cannot generate SSPI context 'Note: There are too many unknowns here to intelligently troubleshoot the situation:

S1 [I am trying to edit a DTS package which is a transfer of data between two tables (connections)]
Q1 Are both tables on the same server or on different servers?

S2 [i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.
Login failed for user 'sa' i am running enterprise manager on the server itself so i shouldn't have any connection issues.]
Q2 i Have you tried entering the login password for sa
ii What is the result then?
iii Can you sucessfully login using say, Query Analyzer as sa?

S3 if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:' Cannot generate SSPI context '
Q3 Are your Sql Server(s) set to use integrated, standard, mixed, etc. authentication?