I am having problems running a DTS package from a stored procedure...
Here is my code:
********************************************************
CREATE PROCEDURE [run_TestDTS]
AS
Exec MASTER..xp_CmdShell 'dtsrun /sql01/testun/testpass/testDTS'
********************************************************
I keep getting this error..
********************************************************
ODBC Error Code = 01000 (General warning)
[Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.c: Error 997 from
GetPassword on line 465
The error occurred while processing an element with a general identifier of
(CFSTOREDPROC), occupying document position (23:5) to (23:64).
********************************************************
I have changed the password, from the owner password, to the user password,
to my login password for SQL..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
