Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


I have created a Dts package from my local server to a remote server and saved the dts package by scheduling every 10 hours but it is not updating the data if i am trying to run it manually it is showing error..

How can i solve this problem please help me its imp for me

share|improve this question
please give us a version & show us the error – Nick Kavadias Aug 14 '09 at 9:20

It's hard to answer this without knowing what versions of SQL Server you're using, which would also tell us if it's DTS or SSIS. It would also be very helpful if you list the error(s) that you are getting.

Since you mention DTS, I'm going to assume here that you're using SQL Server 2000. In my experience, it's usually a permissions issue when you receive errors even when manually running packages. Make sure you're using a login in your connection to the remote server that has all the required privileges on the remote server to do what you need to do.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.