RE: [ cf-dev ] Importing large amounts of data to sql

[Robertson-Ravo, Neil (RX)]

Title: Message

You can call the DTS launch via a Stored Procedure and use SQL to launch the procedure...   DECLARE @hostname VARCHAR(100), @username VARCHAR(100), @password VARCHAR(100), @dtsname VARCHAR(100)   SET @hostname = '' SET @username = '' SET @password = '' SET @dtsname = ''   /* Declare dynamic SQL Statement to Execute DTS */ SELECT @dtsexeccommand = '"dtsrun  /S'[EMAIL PROTECTED]' /U'[EMAIL PROTECTED]' /P'[EMAIL PROTECTED]' /N'[EMAIL PROTECTED] +'"'   /* Execute DTS Package */ EXEC master..xp_cmdshell @dtsexeccommand   Excuse any mistakes.....let me know if you want any more info.   N     From: Kola Oyedeji [mailto:[EMAIL PROTECTED] Sent: 14 June 2004 15:12 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Importing large amounts of data to sql   Steve   Any good book recommendations on DTS? Anyone have an elegant way to launch a DTS packages from CF?   Thanks -----Original Message----- From: Steve Powell [mailto:[EMAIL PROTECTED] Sent: 09 June 2004 20:49 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Importing large amounts of data to sql You can script inside DTS packages and get clever if you so wich, heirarchical data set and so on but that's less straightforward. there are some good books on DTS. Its a vastly mis-understood and under-estimated component inside SQL Server.       ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 5:48 PM Subject: RE: [ cf-dev ] Importing large amounts of data to sql   Does this help? http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=18243&forumid=4 Rafe This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com