Hoping I can acquire some insight or workaround to my problem. I'm on SQL2K
SP4..DTS. What I'm doing is running a stored procedure from an execute SQL
task that contains an sp_grantdbaccess call. The task and the DTS work as
intended......but when I run the DTS from another DTS(as a run package task)
I get a failure on that step..why? Because somehow the message "[SOME_USER]
added to role [SOME_ROLE] granted database access to [SOME_USER]." has
bubbled up to the parent DTS package and causes the step to fail even though
it does not if the child DTS is directly run. What's going on here?


Thanks for reading.


Jon