|
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....
|
|
Hi
I have an table which has around 5 million records i need insert those records into another table
when we write Query like this.
Select * into TempEmp from Employee it gets failed due huge volume of records.
i need to insert the records using an BCP...
Answer Snippets (Read the full thread at microsoft):
What exact error message do you get? I need to transfer the ... .
The records using an BCP Command
Hello Prince,
If the "huge volume" is may the problem, then only because of to less free space on disc; a BCP command won't change this issue.
|
Ask your Facebook Friends
|
Hi
I have an table which has around 5 million records i need insert those records into another table
when we write Query like this.
Select * into TempEmp from Employee it gets failed due huge volume of records.
i need to insert the records using an BCP...
Answer Snippets (Read the full thread at microsoft):
What exact error message do you get? I need to transfer the ... .
The records using an BCP Command
Hello Prince,
If the "huge volume" is may the problem, then only because of to less free space on disc; a BCP command won't change this issue.
|
|
Hi Guys,
BCP Command below is not working...please help on it..thanks
SET @SQLString = 'bcp "Exec Automation..[test] ''' + @ID + ''',''' + @ID2 + ''',''' + @ID3 + ''',''' + @ID4 + ''',''' + @ID5 + ''',''' + @ID6 + ''',''' + @ID7 + ''',''' + @ID8 + '''...
Answer Snippets (Read the full thread at microsoft):
My first guess would be that one of your variables is NULL Thanks Chuck Pedretti
bcp "Exec code to this (note queryout is not....
That to a command prompt then it submits the command at the carriage return
SET @SQLString = 'bcp command is.
|
|
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.
|
|
On Mon, 16 Nov 2009 05:14:46 -0800 (PST), joe <jcharth@gmail.com
Hi I was able to bcp out all my tables except for one. I ran the dbcc
command to repair text fields but I got the same problem. I also tried
select into another table. I got many ...
Started by joe on
, 12 posts
by 5 people.
Answer Snippets (Read the full thread at omgili):
bcp with text columns you need to specify the maximum length
you expect your columns to be or else it will use ASE's default of 32768:
% isql -Usa -P
12
-----------
32768
See the bcp "-T
Thanks for the quick reply I tried ....
|
