Enter Keywords:
Search Within Results
 
 
Narrow Results
Can't Find a Solution
 
 
 
1 - 9 of 9(0.001 seconds)
Sort By:
 
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...
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...
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...
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...
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...
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...
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...
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...
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...
Zones: MS SQL ServerDate Answered: 11/08/2008 Rating: 7.8 Views: 0
 
  • 1