集成项目以将SQL Server表加载到excel文件中 [英] integration project to load SQL Server table into excel file

问题描述

I use Visual Studio's, integration project to load SQL Server table into <pre lang="xml">excel file. In the Sql Table, i have defined columns as varchar. When i try to load Sql table data with parts defined in scheme as string, i get an error &quot;cannot convert between unicode and non-unicode string data type.

推荐答案

此消息表示数据流组件正在尝试将Unicode字符串数据传递到另一个期望在相应列中包含非Unicode字符串数据的组件，反之亦然.
检查以下链接以获取解决方案

DTS_E_CANNOTCONVERTBETWEENUNICODE ANDNONUNICODESTRINGCOLUMN [ Excel目标错误:列"xx"无法在Unicode和非Unicode字符串数据类型之间转换 [

This message indicates that a data flow component is trying to pass Unicode string data to another component that expects non-Unicode string data in the corresponding column, or vice versa.
Check below links for solution

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN[^]

Excel Destination Error: Column"xx" cannot convert between unicode and non-unicode string data types[^]

这篇关于集成项目以将SQL Server表加载到excel文件中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！