excellent.. I think I will go for the SP route rather than the object/COM route... seems more logical.
-----Original Message----- From: Steve Martin [mailto:steve.martin@;sequence.co.uk] Sent: 06 November 2002 11:05 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] DTS There's no performance issues as such, the DTS runs just as it would if it were invoked from EM. > -----Original Message----- > From: Robertson-Ravo, Neil (REC) > [mailto:Neil.Robertson-Ravo@;csd.reedexpo.com] > Sent: 06 November 2002 11:01 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] DTS > > > 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] -- ** 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]
