Stored Procedure help

[rlatham]

I am running a page with this code, but it doesn't seem to be working...the table to be affected is not changing.

The dts package is saved in the SQL Server.

Please, could anyone tell me what am I missing or doing wrong ?

<cfstoredproc procedure = "DTS_FILE2"
  dataSource = "CATS"
 username="kitty" password="meow"
   dbName = "dbCATS"
   returncode="yes"  > 

</cfstoredproc>

The stored procedure:

CREATE Procedure dts_file2 
AS 
Begin 
execute master..xp_cmdshell 'dtsrun /S "FoodServer" --Server name
/E
/N "tblUpdates_drop_recreate_import"' -- Package Name

End
GO

Thanks,

 

[philhege]

Does the CFserver service account, or the DSN login account, have the proper rights to run xp_cmdshell?

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.