CODEWITHSUNDEEP
sqlsql-serverbulkinsert
Debby Pulido
Debby Pulido

Reputation: 55

SQL Server : Bulk Insert 0 Rows Affected

I'm new to SQL and I'm attempting to do a bulk insert into a view, however, when I execute the script the message says (0 row(s) affected).

This is what I'm executing:

BULK INSERT vwDocGeneration
FROM '\\servername\Data\Doc\Test.csv'
WITH
( 
    Fieldterminator = '|',
    Rowterminator = '\r\n'
)

I've confirmed the row terminators in my source file and they end with CRLF. The view and the file being imported have the same number of columns. I'm stuck! Any ideas would be greatly appreciated!

Upvotes: 2

Views: 4018

Answers (2)

Debby Pulido
Debby Pulido

Reputation: 55

Per Mike K 's suggestion I started looking at key constraints and after I adjusted on of them I was able to use the bulk insert! FYI I did insert into the view because the table had an additional field that wasn't included in my CSV file. Thanks for confirming its possible @Gordon Linoff.

Upvotes: 2

Sarin Vadakkey Thayyil
Sarin Vadakkey Thayyil

Reputation: 954

If you are looking for the number of rows affected by that operation, then use this.

DECLARE @Rows int
DECLARE @TestTable table (col1 int, col2 int)

// your bulk insert operation

SELECT @Rows=@@ROWCOUNT
SELECT @Rows AS Rows,@@ROWCOUNT AS [ROWCOUNT]

Or you can first bulk insert into a table, then create an appropriate view from that table.

Following article might be useful -

http://www.w3schools.com/sql/sql_view.asp

http://www.codeproject.com/Articles/236425/How-to-insert-data-using-SQL-Views-created-using-m

Upvotes: -1

Related Questions