Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fh200300us
Starting Member
28 Posts |
 Posted - 2008-02-19 : 15:29:01
|
| I have a query for bulk insert. It works fine. But when I use it today and run into following error message.error 7301:Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".SET @Sql = 'BULK INSERT #FVF_Tmp FROM ''' + @FilePath +'''' + ' WITH (BATCHSIZE = 100000,FIRSTROW = 2,TABLOCK, DATAFILETYPE = '''+ 'widechar' + ''')'EXECUTE (@Sql)The @FilePath points to a .csv filethen use data in temp table inser into a permanent table.The input excel file is .csv file with 5 columns.Thanks in advance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 22:52:03
|
| Try print out @sql to see what you have, maybe have syntax issue in it. |
 |
|
|
|
|
|
bulk insert error 7301