0
[Source Information]
Source Location : .
Source Provider : SQLNCLI11
Table: [Query]
Column: VariableCharacterField
Column Type: 200
SSIS Type: (Type unknown ...)
Mapping file (to SSIS type): C:\Program Files (x86)\Microsoft SQL Server\110\DTS\MappingFiles\MSSQLToSSIS10.XML
官方已经在SQL SERVER 2012 SP2里面修好了问题。不想升级的话，有个work around就是自己去更改MSSQLToSSIS10.XML文件。具体见
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/97ff1f01-c02a-4c9a-b867-8eaecc464cfb/2012-sp1-no-longer-recognizes-common-data-types?forum=sqlintegrationservices
官方文档https://connect.microsoft.com/SQLServer/feedback/details/772761/dtswizard-in-sql-2012-sp1-no-longer-recognizes-nvarchar-varchar-data-types-when-source-is-a-query
Posted on
Wednesday, October 22, 2014
by
醉·醉·鱼
and labeled under
sql
[Source Information]
Source Location : .
Source Provider : SQLNCLI11
Table: [Query]
Column: VariableCharacterField
Column Type: 200
SSIS Type: (Type unknown ...)
Mapping file (to SSIS type): C:\Program Files (x86)\Microsoft SQL Server\110\DTS\MappingFiles\MSSQLToSSIS10.XML
官方已经在SQL SERVER 2012 SP2里面修好了问题。不想升级的话，有个work around就是自己去更改MSSQLToSSIS10.XML文件。具体见
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/97ff1f01-c02a-4c9a-b867-8eaecc464cfb/2012-sp1-no-longer-recognizes-common-data-types?forum=sqlintegrationservices
官方文档https://connect.microsoft.com/SQLServer/feedback/details/772761/dtswizard-in-sql-2012-sp1-no-longer-recognizes-nvarchar-varchar-data-types-when-source-is-a-query
Post a Comment