Looks like its just you and I then steve :-) What kind of performance have you found with the SP method?
-----Original Message----- From: Steve Martin [mailto:steve.martin@;sequence.co.uk] Sent: 06 November 2002 09:57 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] DTS There are a number of ways of running a DTS and I would appreciate any insights anyone else may have as to the most appropriate methods of invoking one from CF. At present I simply call the following SP: CREATE PROCEDURE [dbo].[sp_RunDTS] AS DECLARE @execcommand varchar(100) select @execcommand = '"dtsrun /S 127.0.0.1 /N YourDTSPackageName /E"' exec master..xp_cmdshell @execcommand GO Though it doesn't seem too happy if I attempt to run it as anything except SA when the package copies to a remote server. This isn't however a major issue as the DTS is for a back end process on an internal server and I have the scripts prompt the user (who will always be the sysadmin anyway) for the password which then gets passed through to the SP call and then promptly forgotten. Steve > -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: 06 November 2002 09:22 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] DTS > > > Anyone had any success stories with running DTS packages via > CF? I know > you can do it one of three ways : Stored Procedure, cfexecute or via > cfobject. > > Does anyone currently run DTS and CF together?... > > Neil > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
