Aaron,
the DTS sounds VERY good and USEFUL on paper,
but I didn't know how to use it on MULTIPLE files
where the datasource, is, in fact, 100s of 1000s of txt
files..
do you know how to batch import a complete directory,
for example?
Michael.
----- Original Message -----
From: "Aaron Rouse" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 5:34 AM
Subject: Re: the big export
> If this is going into SQL Server, why not use DTS within SQL Server to do
> this? If it is going to be more than a one time thing, then you could
make
> a CF page to upload the files to the server and then execute the DTS
package
> via CF.
>
> ----- Original Message -----
> From: "Jason Lotz" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 17, 2001 3:55 PM
> Subject: Re: the big export
>
>
> > What exactly do you mean? You could use VB, C, C++, ASP, ColdFusion,
etc.
> > Are you asking what would be fastest? If so, I would recommend VB or C,
> but
> > I have no idea what languages you know. Why don't you just write it in
CF
> > if you are most familiar with it and just let it run for awhile? No
> matter
> > what language you use, it's not going to be quick.
> >
> > ----- Original Message -----
> > From: "Michael Lugassy" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Thursday, May 17, 2001 9:48 AM
> > Subject: the big export
> >
> >
> > I need the fastest way to export 100s of 1000s of text
> > files into a database. I need each file in a a new row like this:
> > file1name, file1content
> > file2name, file2content
> >
> > CF is too slow for this, what can I use?
> >
> > Thanks,
> >
> > -=Michael.
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists