Can some one help me I have a ssis package i have to schedule this every day and i am succeeded in my local server but when i try to deploy in another server it will fail. nethan

Please provide us Error Messages, so we can give you a better suggestion.

1) How is the package scheduled ? 2) If it through SQL Server Agent , you can check this with respect to permissions http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e13c137c-1535-4475-8c2f-c7e6e7d125fc 3) If more details around error , that would really help.Happy to help! Thanks. Regards and good Wishes, Deepak. In a revamp of my Blog!

The SQL Agent needs to have ownership of the package before it can run it as a job. As you created it on your machine the package is no doubt authored by you. There is a something you can do to get around this. Open the package on your machine, go to the properties of the package (same place where you set the password). Change the author to reflect the service account your SQL Agent is running under, you should update the GUID (left click the guid and it will over the option create a new one) as well. Here is the KB from Microsoft for this. http://support.microsoft.com/kb/918760