THANKS!

"Make sure you have Set NOCOUNT ON and SET ANSI_WARNINGS OFF."

After including these statements as first two rows in my stored procedure, i was finally able to access two different databases (select from DB1, insert into DB2) in the stored procedure, when called from DTS.

(SQL Server 2000)

martin