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 - 2002-03-12 : 09:40:23
|
| Craig writes "I run the dtsrun utility from a MSDOS window:dtsrun /Sserver_name /Npackage_name /Uuser_name /Ppasswordthis runs fine, the DTS package imports a text file from a network directory into a table.When I try to run the dtsrun utility from a stored procudure:EXEC master..xp_cmdshell 'dtsrun /Sserver_name /Npackage_name /Uuser_name /Ppassword'I get the following error(s):DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: Copy Data from gehe to [Epos].[dbo].[GeheDat] StepDTSRun OnError: Copy Data from gehe to [Epos].[dbo].[GeheDat] Step, Error = -2147217887 (80040E21) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0Error Detail Records:Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0DTSRun OnFinish: Copy Data from gehe to [Epos].[dbo].[GeheDat] StepDTSRun: Package execution complete.I believe that it is something to do with permissions / access to network drives, as if I change the DTS package to import the file from a local drive instead of a network drive it works OK.Can anyone please help as this is causing me extreme grief.Thanks, Craig" |
|
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
Posted - 2002-03-12 : 11:02:20
|
| Not sure if this is the reason or not but I had some problems similar to this. My problem was using mapped network drives - solution was to use the "proper" path (I'm not sure of the techy name for this - you know \\server_name\share_name\...etc)============The Dabbler! |
 |
|
|
|
|
|
dtsrun utility problems