DTS and permissions

I'm developing a DTS package which will be scheduled and will write files out to a LAN share. When I execute the package manually from enterprise manager it works just fine. But when scheduled..fails with a access denied. Can someone point me towards the area I need to fix this? I'm running the SQL server under the System account.

Thanks,
EYeah...when you run the DTS package from your client, it runs under the context of your id (not to mention the mapped paths that you have).

When it's scheduled it runs under the context of the sql server service account (not to mention it's mapped drives)

Drove me NIUTS when I installed 7

What Id di was to map one of my drive to look exactly as the servers D:\ Drive

That way If I ran it or scheduled a package it would run fine...

If your problem is that you're trying t write from the server to another server, you'll need permissions for the sql server service account to that other server...

Why not write it out to the server itself if that's the case...

Good Luck|||Hi, lil_elvis2000

You should configure a domain user account to run SQL Server Service and SQL Server Agent Service.
You also have to grant write permission to that account on the lan share.

Regards,

Originally posted by lil_elvis2000
I'm developing a DTS package which will be scheduled and will write files out to a LAN share. When I execute the package manually from enterprise manager it works just fine. But when scheduled..fails with a access denied. Can someone point me towards the area I need to fix this? I'm running the SQL server under the System account.

Thanks,
E

DTS and ASP

I am developing a webapplication that should allow users to upload their database by means of a textfile and to integrate that data into an sql table. There will be some logic that deletes duplicates and more.

Trying to make this process as user friendly as possible I would like to allow the user to allocate his fields to the fields in my table.

Is there a way to utilize the transformations process of DTS on an ASP page?

Any ideas on how to achieve this would be highly appreciated.

eWW, SwitzerlandI have never really done anything like this before and I think you will have one he#% of a time making it work... and to be honest I don't think it's possible either. The only way I can think of that probably would work is to tell you users what their field-names should be and in what order. But then again, I'm no expert in this area...|||I wonder, would it be possible to do the actual transformation process outside SQL Server (e.g.) in ASP and to forward the resulting transformation definition by means of parameters to DTS?

You can probably tell, that I am not really familiar with the actual programming end of SQL and would appreciate any cookbook kind of advice as to how to go about and do that.

Best

eWW