Thats a good idea, but when i was writing the code noticed that the SSIS package connection was for the database in question, not the Master database! changed the SQL task to point to a newly created master database connection.. bingo it worked.... now going to stand in the corner for a bit

Thanks for taking the time to respond! it's appreciated. Have a good xmas/ new year/ holidays!

Jon