求救-SQL server 2005 导出到EXCEl 出错

来源：百度知道 编辑：UC知道 时间：2024/06/30 16:29:12
导出操作最后一步报错，
Validating (Error)
Messages
Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Destination - ba" (31).
(SQL Server Import and Export Wizard)

Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (51).
(SQL Server Import and Export Wizard)
哪位大哥前辈能指点下吗，实在搞不懂啊

导入导出一步就可以搞定了
1.导出到文本文件
exec master..xp_cmdshell 'bcp " select * from hrm..t_emp where leave_flag=''N'' " queryout d:\emp.txt -c -U "test" -P
"123"'
2.导出到excel表格
exec master..xp_cmdshell 'bcp " select * from hrm..t_emp " queryout d:\emp.xls -c -U "test" -P
"123"'

2005里面应该可以直接复制粘贴