After installing CU3 for SQLServer 2008 R2 SP2 the Import export wizard fails with the following error while importing-exporting data from a SQL database, selecting "Query" as data source, [Source Information]Source Location : xxxxSource Provider : SQLNCLI10Table: [Query]Column: VarcharFieldColumn Type: 200SSIS Type: (Type unknown ...)Mapping file (to SSIS type): C:\Program Files (x86)\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XMLThe unknown data types are:[varchar][nvarchar][text][ntext][varbinary][xml][image]How to reproduce the bug:1. Create table using the script belowUse [TEST]GOCREATE TABLE [dbo].[TestExport]( [VarcharField] [varchar](100) NULL, [NvarcharField] [nvarchar](100) NULL, [TextField] [text] NULL, [NtextField] [ntext] NULL, [VarBinaryField] [varbinary](50) NULL, [XmlField] [xml] NULL, [ImageField] [image] NULL)2. Right – click on Database TEST and select Tasks -> Export Data3. On Data Source page select the SNAC 10 (the same behaviour is with the Microsoft OLEDB provider for SQL Server)and database TEST4. On Destination page select SNAC 10 (the same behaviour is with the Microsoft OLEDB provider for SQL Server) and new/existent database5. On Specify Table Copy or Query page select Write a Query to Specify the Data to Transfer and then write the query below and click Next and then Next againSelect * from Testexport6. On reviewing Data Mapping page you will see the error: Found 7 unknown column type conversion(s) You are only allowed to save the package7. If you select Copy data from one or more tables or view on the step 5 the data is exported without any issue.8. The issue is NOT reproduced with the .NET Framework Data provider for SQL Server. Additional informations:- The file C:\Program Files (x86)\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS10.XML is correct and contains the nodes for said data types;- the problem is in the client, not in sql server engine: if i try the same export from the same database, using another client version, it works fine.
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization
Please wait...