May 19, 2008 at 2:57 pm
People,
I hav a problem.
If a run a DTS package from Entreprise Manager (SQL Server 2000), that manage some files in the server, with ftp and others, always with user sa, it runs without problems. But when i call the same DTS package from an ASP application, same user, it returns an error.
We have a security problem, yes, but i don't now if it is relationated with sql server security context or windows server 2000 context.
¿Do you have any idea?
Thanks
May 19, 2008 at 3:07 pm
What error is returned?
Greg
May 20, 2008 at 11:58 am
Greg,
The DTS fails when wants to read data from temporal directory of the server (the same server where is install the sql server).
One step before, the same dts write the data (that had taked from another source) in the same directory of the server.
The dts write data, but when he wants read, fails.
Thanks, Mariano.
May 20, 2008 at 2:01 pm
marianodios (5/20/2008)
Greg,The DTS fails when wants to read data from temporal directory of the server (the same server where is install the sql server).
One step before, the same dts write the data (that had taked from another source) in the same directory of the server.
The dts write data, but when he wants read, fails.
Thanks, Mariano.
Find a way to put in a short delay. Give the writing process some time to close the file. It's possible it's not quite done when you try to open it.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply