I have a DTS package that imports data from an Access database, and it works fine from my computer. When I try to run it from the Web, the import task fails. I'm assuming it's because the Web app cannot find the directory and file that the DTS package is looking for. Is there a way to direct the package to the existing file (it's on a common drive and folder to everyone in the company)?

Thanks for any guidance.

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

what error are you getting?

Regards

Partha Mandayam
Software Consultant
Home page: http://partha.tripod.com


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

The page that executes the package also writes the status of each step in the package. The only error I get is: "Step [Copy Data from new_tblVenItem to [AccountsPayable].[dbo].[new_tblVenItem] Step] failed"

The table in the Access database that I'm importing from is called "new_tblVenItem" as is the table in the SQL Server database.


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...