Thanks a bunch for the reply. I don't have access to the query right now. There is nothing wrong with the query, I suppose, because the generated dtsx runs fine when executed separately. I guess it has to do with file permissions. I will read up about deployment on server.