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

[Kola Oyedeji]

Title: Message

Mark, Neil, Barry - Thanks I had looked into this before and had thought it only possibel using a .bat file.

 

Rgarding Barry's question - I'll try it with a dedicated DSN/Account and let you know how it goes

 

Kola

-----Original Message-----
From: Barry L Beattie [mailto:[EMAIL PROTECTED]
Sent: 14 June 2004 16:13
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Importing large amounts of data to sql

just chipping in, for a point of clarification:

It's a good idea Neil but xp_cmdshell is pretty powerful since it's part of the master db. I've had more than one (el-cheapo) host deny this in their SQLServer support. I didn't need DTS (etc) so I just wore the limitation. So I've never used xp_cmdshell without having SA access (ie: never with CF), although I'm sure it's done elsewhere.

Any idea what the min permissions for a SQLServer account would be to access xp_cmdshell?  - since the CF account won't be a member of the sysadmin server role.

would you set it just for that proc, or create a new account (and create a new DSN with those credentials), or add it to the existing CF-accessable profile?

just a thought on Kola's question
thanx
barry.b

----- Original Message -----
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
Date: Mon, 14 Jun 2004 15:37:36 +0100
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: [ cf-dev ] Importing large amounts of data to sql

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

--

__________________________________________________________
Sign-up for Ads Free at Mail.com
http://www.mail.com/?sr=signup

-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]