SQL error Description: OLE DB provider for linked server (NULL)

SQL error Description: OLE DB provider for linked server (NULL)

importing data into SQL Server2005 is an error "SQL Error description: Link server ' (null) ' OLE DB provider ' STREAM ' returned to column ' [!] Bulkinsert].field ' Invalid data ', with the latest patch for SQL Server2005, has the same problem in SQL Server2008.

Baidu, some people say that seems to be an undisclosed bug in SQL 2005, there is no such problem in SQL Server2000.

Solve:

Increase the parameter 4808 during SQL Server startup.

1. In SQL Server Configuration Manager, click SQL Server Services.

2. In the right pane, right-click SQL Server (< instance name >), and then click Properties.

3. On the Advanced tab, in the Startup parameters box, type;-t4808 (plus semicolons and-t4808).

4. After the setup is complete, restart the SQL Server service and perform "DBCC tracestatus" in Query Analyzer.