July 30, 2004 at 2:31 am
I'm new 4 stuff like this..
I'm using DTS Designer (and put several FTP task objects)
I keep getting the following error :
Error string: Can not transfer file O:\DATABASE\STANDARD\KURSCUR.DBF from the source directory to the destination directory. Please make sure the directories exist and you have sufficient rights to access them.
Error source: File Transfer Protocol Task Help file: Help context: 0 DTSRun OnF... Process Exit Code 2. The step failed.
Is there a way to substitute user login from Windows 2000 Domain into Novel Netware Server ?
What object should I add (Designer) more to resolve this ?
thx & best regards,
Nathan
August 1, 2004 at 10:33 pm
An admin could set up a gateway server for Novell on a Windows server. That's one method.
When you are running the DTS package, are you doing so through Enterprise Manager or with a scheduled package via SQL Server Agent? If the latter, keep in mind that you don't have access to mapped drives without the use of some other tools (there's one in the Windows Resource Kit to map drives at startup but I don't recall if it can handle the Novell login).
K. Brian Kelley
@kbriankelley
August 1, 2004 at 11:19 pm
When running the package manually it running fine (maybe coz the user already login to Novell server too I guess..). I use UNC name and path to call our Novell Server name & path (use FTP Task).
but when running the package via SQL Server Agent always gettin those errors...
Thx for the response, maybe I'll try another method
August 2, 2004 at 12:36 am
If the job is owned by a member of the sysadmin role, make sure the SQL Server Agent service account has rights. if the job is owned by an account that's not a member of the sysadmin role, check to make sure the SQL Server Agent proxy account is set. Verify that the account specified has rights.
Also, unless O:\ is a local drive to your SQL Server, the error message would indicate a UNC path is not being used. Rather, the O:\ drive is what is set for the path.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply