Symptoms

Assume that you have applied cumulative update package 2 (CU2) or later to Microsoft SQL Server 2008 R2 Service Pack 2 (SP2). When you try to move data in SQL Server Management Studio (SSMS) by using export/import data wizard with "Write a query to specify the data to transfer" option, you receive the following error:

Found 1 unknown column type conversion(s)
You are only allowed to save the package

further Details
[Source Information]
ource Location : <ServerName>
Source Provider : <DataBaseName>
Table: [Query]
Column: <ColumnName>
Column Type: <TypeID>
SSIS Type: (Type unknown ...)
Mapping file (to SSIS type): <FilePath>\MSSQLToSSIS10.XML

[Destination Information]
Destination Location : <ServerName>
Destination Provider : SQLNCLI10
able: [dbo].[Query]
Column: <ColumnName>
Column Type: <TypeID>
SSIS Type: (Type unknown ...)
Mapping file (to SSIS type): <FilePath>\MSSQLToSSIS10.XML

[Conversion Steps]
Conversion unknown ...
SSIS conversion file: <FilePath>\DtwTypeConversion.xml


Note The issue also occurs in SQL Server 2012 and SQL Server 2014.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×