The database that I try to access in my query in the package gets restored in the same time when my package runs. If those two things clashs I get the error message. How do I make it retry in 5 minutes for example? Thanks Marina

If you're using SQL Agent, there is a retry on failure option there.Otherwise, SSIS by itself can't do this.

Thanks for the prompt reply CanI at least test the connection to the database in packagebefore I decide what I am going to do? If yes how to do it?

Yes, you can use a script task to test the connection. You'd just use the OLE DB classes in .NET. You'd probably need to set the DelayValidation property to true on the connection manager and any other tasks that use the connection.

thanks that worked

raf Thanks.