Thanks guys - works a treat!

Hi guys - thanks for all your input, checking 'fail package on step failure' seems to be the logical answer to this - I'll give it a try.

rw

Hi Phill

We aren't explicitly handling 'failing' a child package. I assumed that if a step failed within the child, and therefore the child package itself failed, then it would return...

In reply to Steve:

this is related to my previous post on management of temporary files created in an sp and then called by DTS:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=13334&FORUM_ID=19&CAT_ID=3&Topic_Title=procedure+failing+when+called+from+DTS&Forum_Title=Data+Transformation+Services+%28DTS%29

the SP in question...

Hi

it doesn't seem to matter if it is a temporary table or a physical table - parsing the query in the Exec SQL task complains about the table name, wherever...

Guys

thanks for all the input - it turns out that it is an sp_change_users_login fixable problem, but its all about the order in which events take place. The problem is...

I've already tried sp_changedbowner, but as the user warehouse already exists - i get 'The proposed new database owner is already a user in the database.'

I will try your proposed...

Hi

sp_helpuser returns:

username groupname loginname defaultDB

dbo db_owner sa master

sysdba ...