On 4/6/06, Jeremy Bunton [EMAIL PROTECTED] wrote:
I need something I can run in a .bat file as it loads in a batch server.
These databases have about 20 million records and the files can be quite
large. CFFILE might time out, trying to write out a file with 80 fields and
50,000 records.
BCP
to a
csv file in my user specific directory. Seems easy, hopefully it is in SSIS.
Jeremy
-Original Message-
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Friday, April 07, 2006 7:36 AM
To: CF-Talk
Subject: Re: SQL 2005 and getiing data out
On 4/6/06, Jeremy Bunton [EMAIL PROTECTED
Yeah both BCP and sqlcmd are reall fast and work well EXCEPT they both have
a limit on the length of the arguments you can use at the command prompt. If
not for that I would be done. I guess I am going to have to look at SSIS.
All I need to do is pass a query and export the data from that query to
On 4/7/06, Jeremy Bunton [EMAIL PROTECTED] wrote:
Yeah both BCP and sqlcmd are reall fast and work well EXCEPT they both have
a limit on the length of the arguments you can use at the command prompt. If
To limit the length of the argument I was thinking you could do
something like...
cfquery
What about using CF to do it? Query the DB and use cffile to dump out a
csv.
-Original Message-
From: Jeremy Bunton [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 06, 2006 8:12 AM
I have an application that needs to run a query against a
2005 database and
then export that
[mailto:[EMAIL PROTECTED]
Sent: Thursday, April 06, 2006 10:45 AM
To: CF-Talk
Subject: RE: SQL 2005 and getiing data out
What about using CF to do it? Query the DB and use cffile to dump out a
csv.
-Original Message-
From: Jeremy Bunton [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 06
In SQLServer2005 they've done away with DTS ( which annoys me because
it was the primary task i used Enterprise Manager for in the SQL2K
database) and replaced it with SSIS - a far more flexible and
programmable method of data import and export. It can loop through
fields, have quite a lot of
7 matches
Mail list logo