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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-05 : 07:23:44
|
| Tibi writes "Hi,I have a stored procedure which triggers a DTS package.The package is meant to be reading a text file situated on one side of a firewal and update a database table situated on the other side of the firewall.However, when I design the package and run it from the sql server itself it's ok, no probs but when I trigger my stored procedure that in turns trigger the package from a web application this does not work. Viewing the history log for the job of this DTS package it says:"Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string: Error opening datafile: The system cannot find the path specified. ..."What permission settings shall I use for my shared mapped networked drive that contains the file? I ve tested it with various numbers of access permissions but still not working.The only way it works from my web application is when I place the file on the same machine with my sql server and my web application.Any clues on this?Thank you in advance.Tibi" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2003-08-05 : 10:08:38
|
| The account running DTS must be able to see the file on the other side of the firewall. Try logging into the server with the account that runs SQL Agent and see if you can see your shared drive. If not, then you'll have to make some permission changes. |
 |
|
|
|
|
|
The datasource path for a DTS package not found