I have a table, say students, which downloads from a mainframe daily. Each time maybe 90% is the same and 10% are new. I have a unique key on a column, say student_id.
When i tried to use bcp it...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10204810.html
Zones:
MS SQL ServerDate Answered: 03/15/2002 Rating: 8.4 Views: 0
Hi guys, hope you all are doing fine, guys I am having a trouble I am using the bcp utility to copy the data from one table to a text file but I just wanted to give two date parameters in that so t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21131619.html
Zones:
MS SQL ServerDate Answered: 10/12/2004 Rating: 7.6 Views: 0
Hello,
I want to copy some data stored in a text file to a SQL Server table. Some fields contain long text, and I want to use ntext SQL Server data type to store these fields.
But the bcp utilit...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20239455.html
Zones:
MS SQL ServerDate Answered: 11/29/2001 Rating: 7.6 Views: 0
I am using Python to parse a data file. I would like to BCP the file into SQL Server 2005 from my Python script. Is there a module that would allow me to do this? If not how can I call the external...
http://www.experts-exchange.com/Programming/Languages/Scripting/Python/Q_22023794.html
Zones:
PythonDate Answered: 11/26/2006 Rating: 8.0 Views: 4
Hello experts,
I am trying to BCP a .txt file data into Sybase database but getting the following error:
"Unexpected EOF encountered in BCP data-file"
I am doing this from MS-DOS prompt.
He...
http://www.experts-exchange.com/Database/Sybase/Q_23555364.html
Zones:
SybaseDate Answered: 07/11/2008 Rating: 8.6 Views: 124
Hi!
I am using sql 7.0 on Win NT.
I have to dump records from .txt file into database for which I am using this command
BULK INSERT stockmoves..reuters FROM 'c:\test.txt'
WITH (
DATAFI...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10207793.html
Zones:
MS SQL ServerDate Answered: 03/14/2002 Rating: 8.4 Views: 0
I wana trasfer a SQL 6.5 data base table to be a excel acceptable file format,
but don't knowhow to do it. SQL 7.0 seems has the DTS feature but I must use SQL 6.5. according the SQL book seems on...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10907241.html
Zones:
MS SQL ServerDate Answered: 08/06/2000 Rating: 7.6 Views: 0
I've a batch file which uses SQL Server's
BCP utility to perform some operation.
For e.g
BCP <Table Name> in <File Name> -E -n -q -S %2 -U%1 -P%1
The batch file also sets the PATH and CLASSP...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_20397522.html
Zones:
VB DBDate Answered: 09/04/2003 Rating: 8.2 Views: 0
BCP will not work - I can not get a connection - any thoughts?
bcp "server.dbo.view for horizon" out "c:\mytest.txt" -c -t, -U [user] -P [pw]
The user is a a SQl server suthentication account...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23868014.html
Zones:
MS SQL ServerDate Answered: 11/08/2008 Rating: 7.8 Views: 0
