Excel into SQL Table

[NotSQL]

Hi, I’m having problems importing data from excel to a table in sql server 2000. I have a DTS package which picks this data up and transfers it into the table. However, this tasks works fine when run manually but doesn’t work when scheduled. Do any of you have any ideas? This is the error message.

Step Error Source: Microsoft JET Database Engine
Step Error Description:Failure creating file.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003436

 

[AlexCuse]

Try comparing the SQL Server Agent account's permissions (both file-system and database) with your own user account. Odds are you will find a difference, that prevents SQL Agent from successfully executing the package.


Hope this helps,

Alex

[small]----signature below----[/small]
You can't fit a square data in a round table