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 - 2001-06-18 : 09:44:55
|
Craig writes "I am trying to run a DTS package from a stored procedure with the following syntax:
EXEC master..xp_cmdshell 'DTSRUN /S U607ST45 /U sa /P password /N DTS_CATEGORY_FILE'
I get the following errors:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Copy Data from Results to [CFProducts].[dbo].[CATEGORY_FILE] Step
DTSRun OnError: Copy Data from Results to [CFProducts].[dbo].[CATEGORY_FILE] Step, Error = -2147008507 (80074005)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 700
Error Detail Records:
Error: -2147008507 (80074005); Provider Error: 0 (0)
Error string: Unspecified error
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 700
Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8)
Error string: The Microsoft Jet database engine cannot open the file '\\u607st17\Aretail\Products\CFProducts.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003051
DTSRun OnFinish: Copy Data from Results to [CFProducts].[dbo].[CATEGORY_FILE] Step
DTSRun: Package execution complete.
If I run the command from the same PC on a DOS commandline:
DTSRUN /S U607ST45 /U sa /P password /N DTS_CATEGORY_FILE
It works fine.
I am running on Windows NT Server, SQL Server 7 SP3.
I believe that it is some sort of security problem. Can you please shed any light on this.
Regards, Craig Handley" |
|
|
|
|
|
Problem running DTS package from stored procedure