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 : 14:45:42
|
| 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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:24:20
|
| Dup post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97579 |
 |
|
|
|
|
|
bulk insert got error 7301