scheduled DTS fails, runs fine from designer

[skitty123]

I have set up a DTS package to import data from a text file into SQL Server table. Since the text file resides on a different machine on the network, (The Sql Server is local to the machine to which i have mapped the network drive.)
I even tried the UNC name of the drive instead of the mapped letter but i still get an error as follows:
---------------------------
Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Step Error Description:Error opening datafile: Logon failure: unknown user name or bad password.
---------------------------
I think this is proably hapening as the sql server is 'using' a user name to connect to the drive that does ot have permissions. (I use Windows integrated security to login to the sql server) how do i force it to use the windows account to connect to the mapped drive?
(The package runs fine when executed from the Designer, however errors arise when I schedule it or try to run it via code.)

 

[nigelrivett]

Try running the sql server agent using a domain account with permsissions.
If that doesn't work do the same for the sql server service.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[skitty123]

hi I am a bit of a novice with sql server, coudl you please explain in detail? where do i access the domain account/ I am using integrated windows security so I do not ahvea specific user name and password

thx