|
How can I run the Bulk Copy Program (BCP) utility of SQL Server through .Net code?
Started by Rashmi Pandit on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
...and
If you still need bcp utility, then you can run it as a process.
Are some possible options:
From .NET 2.0, we can use SqlBulkCopy class Use BULK INSERT Query Use an integration service package (SISS).
|
|
Hi,
I have created a proc that grabs all the user tables in a local DB on my machine. I want to be able to create a flat file of all my tables using BCP and SQL. Its a dummy database in SQL 2000 connecting through windows authentication. I have set my...
Started by EJ on
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Hi There I am running this from query analyzer because I have 118 tables to output to flat file ?
from the command prompt for customer table only:
C:\Documents and Settings\emullany> bcp:
bcp [HelpDesk-EasyPay].dbo.[customer....
|
|
I'm on a roll today.
I'm try9ing to BCP out some data. the bcp function reports it's running sucessfully, but i'm not seeing the output in any of the locations i'm specifying. The report provided looks thusly, but no data appears in the location:
*** ...
Started by WJHamel on
, 12 posts
by 5 people.
Answer Snippets (Read the full thread at sqlteam):
It's better not to bcp out? Does the query execute fast in SSMS? How big is the file? Only three rows in that particular table, buy are you running the ....
It to be saved to your machine specify UNC path like
\\yourmachinename\folder\.. .
|
Ask your Facebook Friends
|
Hi Guys,
I've been trying to get BCP to work in order to export some data to a CSV file, and I'm not getting too far. The query I am using is
"U:\>bcp TEST.dbo.REQUEST QUERYOUT c:/sqlFile.csv -T -c"
but this throws up the error
"SQLState = 08001, NativeError...
Answer Snippets (Read the full thread at microsoft):
The query I have is
bcp "SELECT <long list of fields> FROM TEST.dbo.Jobs WHERE is running? Try this:
bcp TEST.dbo....
BCP Information
Swap QUERYOUT to just OUT and let me know!
hope lines.
A query to copy data from.
|
|
On Tue, 24 Feb 2009 16:31:59 +0100, Lemat <lemat_hates_spam@lemat.priv.pl
It is none of my bussiness if sender side allows to fake return-path or what
action is performed after the email is rejected by recipient's server. It is
CERN LHC' job...
Started by Lemat on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
He talks about his server refusing in SMTP session to take over
responsibility for message delivery to recipient... .
On Tue, 24 Feb 2009 18:47:16 +0100, Andrzej Adam Filip <anfi@onet.eu
Steve Baker <bakesph@comcast.net
He knows what he talks about .
|
|
On Tue, 27 Jan 2009 13:00:42 -0500, Rick <rick@invalid.net
Thank you to the group for turning me on to BCP's QUERYOUT option. I've
now used it successfully when "query" is (1) a stored procedure --
BCP "exec dbname.dbo.pr_myproc" QUERYOUT TEST...
Started by Rick on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
In SQLCMD it
or, if it fits, type the contents... .
(The -i is for responses to a format file.
There is no provision for feeding a script into BCP.
On Tue, 27 Jan 2009 16:33:13 -0500, "Russell Fields" <russellfields@nomail.com
Rick
BCP.
|
|
I want to export some SQL Server 2005 data to CSV format (comma-separated with quotes). I can think of a lot of complicated ways to do it, but I want to do it the right way. I've looked at bcp, but I can't figure out how to put the quotes around the fields...
Started by jmgant on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at stackoverflow):
Options....
For adhoc queries:
Show results in grid mode (CTRL+D), run query, click top left hand box in results grid, paste to Excel, save as CSV and Query..
Run your query from the Query window and save the results to CSV.
|
|
On Wed, 4 Feb 2009 23:25:47 -0500, "Sylvain Lafontaine" <sylvainlafontaine2009@yahoo.ca
The | symbol is the old pipe command for DOS and many shell, so you must
escape it by using "" or by using its hexadecimal value like (each command
on a single...
Started by Sylvain Lafontaine on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Declare @sql varchar(8000)
Select @sql = 'bcp "exec cmc.dbo.myStoredProcedure '01/01/2009',
'01/31/2009', 'Y'" queryout
c:\bcp\dataoutputfilename.txt -c -t = 'bcp "exec cmc.dbo.myStoredProcedure....
I tried it again.
That really helps.
|
|
How to save query result using T-SQL in a csv file in SSMS 2008? Needs to be done programmatically.
Started by Tony_Henrich on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You could use System.Diagnostics.Process to run the SQLCMD or OSQL or BCP programs to dump out csv.
|
|
On Mon, 15 Jun 2009 07:43:28 -0700 (PDT), Rick <rick0726@verizon.net
I've read in several places on the web that BCP's QUERYOUT can execute
a SELECT from a global temp table in a stored procedure that BCP is
running. But I've never found that to...
Started by Rick on
, 7 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
bcp <rick0726@verizon.net
The stored....
To BCP in/out from a global temp table...
On Mon, 15 Jun 2009 15:54:24 +0100, "Tony Rogerson" <tonyrogerson@torver.net
Hi Rick,
BCP a result set I guess that uses a table variable.
|
