December 27, 2007 at 10:06 pm
Dear all,
In DTS there is one facility 'FTP' to transfer file from interenet/Directory to local machines.
When I execute this task It works well.
I have to schedule it, So I create a job for this.
But after scheduling a job for this, it gets failed.
Yet I have not understood why this is happening.
Other jobs of database backups are working fine..
Plz revert if any one have solution for this..
Regards
Majid
December 28, 2007 at 3:06 am
typically your account will have the correct permissions, the sql service accounts do not. This is pretty basic stuff, have you considered a microsoft training course?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 28, 2007 at 3:34 am
I did not get your answer ??
Regards
Majid
December 28, 2007 at 4:06 am
Can you provide the exact error when you run the job?
December 28, 2007 at 4:56 am
Showing error message--
The job failed. The Job was invoked by Schedule 3 (DataTransfer). The last step to run was step 1 (DataTransfer).
December 28, 2007 at 11:32 am
When the DTS package is run manually it is running under your credentials. When the DTS Package is scheduled to run as a job the package is run under the credentials used to start the SQL Server Agent.
As pointed out earlier, it sounds like your account has some type of permissions that are different from what the SQL Server Agent is set to run under.
For example, the SQL Server Agent might not have file permissions on the destination directory path of the FTP task. Or, if there's a firewall between the SQL Server and the FTP site, rules might be blocking the FTP traffic.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply