Hi,
I have done a DTS package which pull data from a CSV file and copy the
contents to a SQL table.
On the text file source I can put a CSV file which is in another server and
when I run it from SQL enterprise it works fine.

Then I have created a ASP.NET application.
I have included a input file button to be able to browse and select a CSV
file that you want to process and then it passes this file to the data
source, however if the file that I select it is on another server diferent
from the one that I'm opening the browser it fails, it says file it cannot be
found.

Any ideas?

Thanks for your help.

Remember that the location of everything is relative to the place where the
package is invoked. It could well be that the package actually cannot see
the file.

It could also be a case of permissions for the ASP account.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Marc Cardenas" <test (AT) test (DOT) com> wrote

Hi,
The way the remote file is being accessed is
\\servername\c$\foldername\filename

What I have done instead of using c$ I have shared the folder where the text
file works, doing this it works, so maybe is some security related to not
allow a browser to access to a c$ on a remote machine.
However the share folder doesn't work for all the servers on the organization.

Thanks

"Allan Mitchell" wrote:

More news.
I have done the same but isntead of a web app I have done a windows app and
then it works.
Thanks

"Marc Cardenas" wrote: