August 30, 2005 at 3:25 pm
Hi!
I made a Package that have an schedule with the importr export option, so is a job. If I run from DTS folder the package it execute fine but whe the job runs always send errors, this is the log information:
...ing... DTSRun: Executing... DTSRun OnStart: Delete from Table [bdPOS].[dbo].[tbAleatorios] Step DTSRun OnFinish: Delete from Table [bdPOS].[dbo].[tbAleatorios] Step DTSRun OnStart: Copy Data from ID to [bdPOS].[dbo].[tbAleatorios] Step DTSRun OnError: Copy Data from ID to [bdPOS].[dbo].[tbAleatorios] Step, Error = -2147467259 (80004005) Error string: Error opening datafile: The network name cannot be found. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 67 (43); Provider Error: 67 (43) Error string: Error opening datafile: The network name cannot be found. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from ID to [bdPOS].[dbo].[tbAleatorios] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
What the package do is, erase the informacion of table tbAleatorios, and copy the information of a txt file to the table.
I am running the package and the job from enterprise manager and my computer is the database server
I hope you can help me, thanks!
August 30, 2005 at 3:50 pm
When you run the DTS package, it runs with your account, rights and drive mappings. When it runs a job it runs as whatever account is used to start up SQL Server Agent. So this account may not have rights to the file or may not be able to see it the same way you do.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
August 30, 2005 at 4:39 pm
What kind of account I have to create to have right to network drive?
Right now I am using user:sa, with out password.
August 30, 2005 at 5:40 pm
Teresita,
In Enterprise Manager, expand Management and right-click on SQL Server Agent. The account shown as the Service startup account is the one that needs to have access to the network location. If the file is on another server, the startup account will have to be a domain login, rather than SA.
Greg
Greg
August 30, 2005 at 6:13 pm
Ok, the problem here is that the file is on a novell server, I think I undestand what you explain me.
But how can I do to do that a domain login uses a novell drive?
September 1, 2005 at 10:51 am
This is a little beyond me. Check these threads to see if you they help:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=129223
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=54&messageid=132608
Greg
Greg
September 6, 2005 at 9:10 am
Hi!
Strange thing, we have novell servers here, and windows 2000 on our computers, the issue is still with out solution in my computer, I installed the sql server has a server here.
In other two computers my partner and the one that matter the issue was that they run the sql agent using a user named Local Sistem Account , so I went to Start+ Settings + Control Panel + Administrative tools + Services , then I find the SQLSERVERAGENT right click + Properties and change the user on the tab of Log On, I choose This Account, then I put a user with Administration right.
After that the job funtion just find, but in my computer this didn't work, actually I already had the administrator user running the SQLSERVERAGENT, so that is why I never check this property in the other computers I was thinking that they have the same user.
Thanks a lot for you help!
(I hope you undestand my English)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply