Hi all

I've tried about everything. My problem is that I have this .asp page
that executes a DTS Package, this package gets some data from a table,
saves it into a text file. No problem so far.
Now I would like to move the file from my server to another server =
FAIL!!!
Wher i run the DTS Package from Enterprise manager there is no problem
the file gets moved ok but when I execute it from my .asp page it
fails.
On the server where the file should end 'everyone' has write rights.

Does anyone know what to do?

Jais, Mondo A/S, Denmark

What error is returned?

It sounds like a permissions problem.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jais Holstein" <jaisholstein (AT) gmail (DOT) com> wrote

Hi Allan

It dosen't really say a lot. I've used the example I fount on
sqldts.com and created an .asp page. When I run the package it tells me
that the step (step3) failed. Thats all.
My package has 3 steps.
1. gather data fra a table and write to text file.
2. rename textfile
3. Move file from server A to server B (Using a .bat file)
I'v modified the package and tried if it was posible to move the file
from one dir to another on Server A and that is ok. I started with only
step 1 and it would just save the file directly on server B but that
didn't work.

Jais




Allan Mitchell wrote:

Have you tried logging execution of the steps to a text file?
This may yield more luck in troubleshooting this.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jais" <jaisholstein (AT) gmail (DOT) com> wrote

Hi Allan

Happy newyear to you. I've tried adding an error log. It told me that
it was a permissions problem as you suspected.
That just puzzels me because I changed access rights to the asp page
that executes the DTS package. I now log on with my NT username and
password. I have permission to log on to both server A and B and I have
full rights to the destination folder om server B.
Do you know why it still fails?

Jais

Have you had a look here

http://support.microsoft.com/?kbid=252987

It may be that even though you think you are doing the excuting, you are in fact not.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Jais" <jaisholstein (AT) gmail (DOT) com> wrote

Hi Allan

Success. I've now solved the problem. I think it's a mix of several
things. An former collegue of mine told me that the website in IIS
should run in an isolated process. And the security for the webpage
should be windows authentification. I did all that and restarted the
website and it worked.
Thhank you very much for your help

Jais :-)