Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to Access a file on "D" drive through the DTS

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-20 : 08:29:39
Ritesh writes "Hello,

I have a DTS which is running under SQL-SERVER 2000 which is installed on "C" Drive.
I configure my Site in IIS which is physically placed in "D" Drive.
I want DTS to pick the files from my site and send it through the mail as an attachment. But DTS is not able to pick it from "D" drive, when I shifted my Site on "C" Drive it works fine.

Looking for your answer.
Thanx in advance.
Ritesh"

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2004-09-20 : 11:43:36
Are you saying that the files are on the D drive on you SQL Server? Are you running the DTS package via a scheduled job?

Mark
Go to Top of Page
   

- Advertisement -