I am trying to set up as scheduled daily import data from a txt file into SQL Server 2000 table on Window2000 server, when I set up the job as run immediately, it work fine, it doesn't work as scheduled, the message I am getting is about the security issue, which I am not sure, has anyone any idea as to what the problem is, thanks.

Regards

Peter

Hi there,

What may be the problem is that when you run the package, it runs as you. Apparently, you have enough rights to access specific databases or other network resources.

Make sure that the account that SQL Server is running under (or the SQL Server Agent, I am not sure, although on second thought the Agent seems to make more sense) has enough permissions to access the resources your DTS package tries to access.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi, Imar
Thank you for your message.
what do you mean by make sure the account that SQL Server is running has permissions to access DTS package? I have tried schedulling packages using Window's login and specific permission to the Database, both have failed.

king regards

peter

In order to check the account, try this:

1. Open Enterprise Manager
2. Open your server node
3. Open Management
4. Right-click SQL Server Agent.
5. On the General tab, select an account under Service startup account and make sure this account is allowed to do what it has to do in your package.

I think this should do the trick, although I am not 100% sure.

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Many thanks, Imar, it worked.

Peter