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

[Mark Smyth]

Title: Message

Kola   Not sure about the books but in theory you can initiate DTS via a windows batch file and then use cfexecute to start it up.   hth Mark  -----Original Message----- 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