Well here was the problem. I did not use SQL DTS scheduler to do the
jobs. I still cannot get it workin in the query analyzer too. But i
noticed it work from the NT's cmd.exe prompt if i execute dtsrun.exe
with its parameters. But then i also noticed that it would fail there
too if the connection was lost to the Novell Server. We have had
problems in the past and for our smtp connector that it lost and had to
reconnect all the time. So by saying in NT box...
c:\dtns Sservername Npackagename Uuserid << sa no password
forcing it to connect and run. Now in order to schedule these commands
i used VB which u can select what time what commands pauses ect. If
interesed in the source just ask [=
> I ended up using robocopy.exe (nt resource kit) to move all the excel
> off the novell network file server and put them onto the local HD. I
> that with the the server and user account that was failing on he dts
> packages. It can read the files fine now (for some reason).
> time limitations didn't let me figure out the cause. The agent had all
> permissions to the file on the network drive....
> > Andy:
> > On the scheduler when setting up a job step, select Operating System
> > (CmdExec) and put this in the Command window with your appropriate
> > information:
> > dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name
> > /Mpackage-password
> > You can open up a DOS window and copy the very same thing to the
> > run it from there. This helps to see if it will work without
> > around with the job interface.
> > Regards,
> > Mike
> > > Ok I went down to the server and logged on with the SQL Server
> > account
> > > instead of using terminal server to log in with that account. I
> > access
> > > and read the excel file when I execute it from DTS but the
> > > when scheduled. I'm wondering if the SQLCmdExec account has
> > do
> > > with scheduled jobs?
> > > > It shouldn't have to be installed on the executing server since
> > > using
> > > > the OLE DB provider. Have you tried to sign into the server
> > > > account starting SQL Server agent and see if he has permissions
> > > file.
> > > > Can you see the file when you interactively execute the package
> > your
> > > > login permissions?
> > > > --
> > > > Brian Knight
> > > > http://www.swynk.com/friends/knight
> > > > http://www.sqlservercentral.com
> > > > > Does Excel need to be installed on the Server reading Excel
> > > > DTS?
> > > > > We're trying to read these excel files on Novell Servers
> > > > > success. We can get it to work when we run DTS from our
> > machines
> > > > > which have Excel but when I use terminal server into our
> > > > schedule
> > > > > it as a job it fails. Our server doesn't have Excel
> > > > > I know SECURITY is a flag here but the Server Agent is in the
> > > Domain
> > > > > group as we are and was given the same novell login script.
> > we're
> > > > > using UNC naming and the UNC paths I type into explorer while
> > in
> > > > > locally on the server as the Server Agent get me to the files
> > to
> > > > > read.
> > > > > This is the error from the job history:
> > > > > Error string: '\\SERVER\VOL1\FINBUDG\Budget
> > > > > Departments\Expense\Budget2001_FirstLastName.xls' is not a
> > > > Make
> > > > > sure that the path name is spelled correctly and that you are
> > connected
> > > to
> > > > > the server on which the file resides. Error source:
> > JET
> > > > > Database Engine
> > > > > putting this string into explorer on the server get's me to
Sent via Deja.com http://www.deja.com/
Before you buy.