sql server dts: Help: I need to move a file from one server to another from a DTS package -- sql server dts

Re: I need to move a file from one server to another from a DTS package

Jais
12/30/2004 11:10:55 AM

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

[quoted text, click to view]

Re: I need to move a file from one server to another from a DTS package

Allan Mitchell
12/30/2004 6:18:16 PM

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

[quoted text, click to view]

Re: I need to move a file from one server to another from a DTS package

Allan Mitchell
12/30/2004 8:11:20 PM

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

[quoted text, click to view]

Re: I need to move a file from one server to another from a DTS package

Jais
1/3/2005 1:02:57 AM

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

Re: I need to move a file from one server to another from a DTS package

Allan Mitchell
1/3/2005 2:03:08 PM

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

[quoted text, click to view]

Re: I need to move a file from one server to another from a DTS package

Jais
1/4/2005 2:23:47 AM

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 :-)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.