Hi,
What rights does a user need to connect to the server (2005) and
view/run packages from their client PC? Where are they configured?
Thanks

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

DTS only issues regular SQL commands to do its stuff, so unless a
package was password protected, there are no DTS package permissions.

I think you only need to have the regular database and table access
permissions configured. First, setup logins under security folder of
the server instance the database is in using Enterprise Manager
Studio. Next, setup users in the security folder for the database the
package runs against in Enterprise Manager Studio. Finally, setup the
access permissions to the tables in Enterprise Manager Studio for each
user under the securables node when you open the user (Alter, control,
delete, insert, freferences, select, take ownership, update,
viewdefinition.

Jim,

Look at this article. http://www.sqlservercentral.com/Foru...706-146-1.aspx

Norman Kelm

DTS Package Search
http://www.dtspackagesearch.com/