I have a text file, which I want to insert into a table in my database.
My query looks like this:
BULK INSERT myDepartment FROM 'C:\myDepartment-c-t.txt' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = '\t', -- default terminator ROWTERMINATOR = '\n' );
On executing it, SQL Server Management Studio 2008 gives the following error:
'BULK' rowset provider not supported in this version of SQL Server.
I googled it and found that SQL Server 2008 does support
BULK INSERT. Can anyone tell me what am I missing?