sql server dts: Ok, so I'm working on getting a bunch of dts scripts that were set up
under an individual's login set up to work under a generic group login.

None of these logins can get access beyond dbo on a particular
database.

I did a save as on the scripts and saved them to .dts files. If I
load them back in while logged in as the new user I get a weird "access
is denied" error when I go in and try to edit any of the transforms in
the packages. If I go in and delete the transforms and try to recreate
them the window that usual shows the types of transforms is empty.

I'm able to login to the sql server. Is there some other right other
than dbo on this database that I need to be requesting?

Does anyone out there know what is being accessed when SQL Server is
loading the list for the "create new transformation" window? My
strange access is denied error seems to keep that window from being
populated with the usual choices. But only on this particular login.

hi,
could you please be more specific in your request?
--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)


[quoted text, click to view]