Viewing 15 posts - 1,021 through 1,035 (of 1,415 total)
The file you have uploaded called EmployeeDataCommaDelimited.csv.txt looks like it should work with the prior bcp command you first tried, AFTER YOU REMOVE THE FIRST LINE FROM YOUR CSV FILE...
October 22, 2014 at 9:27 am
Just curious, could affected tables with the working database and the database that gets spaces have different ANSI_PADDING settings?
October 21, 2014 at 3:12 pm
You could post the updated data file with commas, and the table definition that you're trying to bcp to, and folks might be able to duplicate your error and troubleshoot...
October 21, 2014 at 2:29 pm
Just some possibilities:
It can depend on the table its getting loaded to and the parameters you have in your bcp command and I don't have adventureworks loaded.
Some other comments, specifically...
October 21, 2014 at 1:27 pm
Brandie Tarvin (10/17/2014)
And as a bonus, we now know what database engine Google uses on its back end, don't we? EDIT: Well, at least we know it's SQLish, not Oracle...
Well...
October 20, 2014 at 7:48 am
Gary Varga (10/3/2014)
chrisn-585491 (10/3/2014)
We've got major apps that will only run on certain VERSIONS (forget platforms) of Java and won't even coexist on a machine.
That's a developer issue that could...
October 3, 2014 at 11:35 am
emmchild (10/3/2014)
October 3, 2014 at 11:30 am
Roy Ernest (9/18/2014)
There is an improvement performance. But Interpreted T-SQL does not perform like the compiled stored procedures. In SQL 2014, there was some major work done on the...
September 18, 2014 at 6:27 am
Roy Ernest (9/17/2014)
September 17, 2014 at 2:28 pm
Roy Ernest (9/16/2014)
Hi Gabriel,In this version of SQL server, the execution of T-SQL statements does not need require that many instructions to execute it.
So does this mean that cursors on...
September 17, 2014 at 12:17 pm
Luis Cazares (9/11/2014)
CELKO (9/11/2014)
September 11, 2014 at 9:34 am
Talib123 (9/8/2014)
Do it via T-sql and set identity insert on-- SET IDENTITY_INSERT to ON.
SET IDENTITY_INSERT products ON
GO
It really sounds like he tried this, but in the destination table the...
September 8, 2014 at 2:32 pm
CELKO (8/22/2014)
What do you use for the PK on lookup tables?
I use the encoding that is being used. The IDENTITY property (not a column!) is the count of insertion...
August 29, 2014 at 8:41 am
WILD GUESS!
I'm thinking that internally to SQL Server, the column is referenced by an ordinal value, like column number. When displaying information about the index to the user in ssms...
August 28, 2014 at 6:59 am
Viewing 15 posts - 1,021 through 1,035 (of 1,415 total)