SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
Sql Server 2019 Import Export Wizard Unable to cast object of type system.dbnull
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 10%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Binway
716
Reputation points
I am using the Sql Server 2019 Import export wizard to copy data from 16 tables in an Azure Sql Server Database to another Azure sql database in the same subscription, resource group etc. The wizard works fine for a table or two sometimes but when it fails or I select multiple tables I get this error:
- Setting Destination Connection (Error)
Messages
Error 0xc0047062: Destination - CapitalWork [97]: System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.Type'.
at Microsoft.SqlServer.Dts.Pipeline.ADONETDestination.SetMetadataValsFromRow(DataRow currRow, String& name, Int32& codePage, Int32& length, Int32& precision, Int32& scale, DataType& dtsType)
at Microsoft.SqlServer.Dts.Pipeline.ADONETDestination.SetExternalMetadataInfos(IDTSExternalMetadataColumnCollection100 iDTSExtCols, DataTable metadataTbl)
at Microsoft.SqlServer.Dts.Pipeline.ADONETDestination.ReinitializeMetaData()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper) (SQL Server Import and Export Wizard)
Unable to cast object of type 'System.DBNull' to type 'System.Type'. (Microsoft.SqlServer.DTSPipelineWrap)
The tables have a range of record counts from 1 million down to 1, the million record table works fine when activated by itself.
Thanks
{count} votes
-
Ronen Ariely 15,201 Reputation points2023-02-26T11:46:58.04+00:00 Hi,
I am using the Sql Server 2019 Import export wizard
SQL Server does not have any wizard or any GUI. It is a set of services which run in the background and we control using queries.
My guess is that you are using SQL Server Management studio which is a client application to manage servers/database like SQL Server.
I assume that this the tool that you speak about:
Please confirm if this is what you do
Note! The error "Unable to cast object of type ‘System.DBNull’ to type ‘System.String’." can raise from different reasons. You should try to use Extended Events to monitor the source of the issue. In addition please check the SQL Server error log file for any more information.
Sign in to comment
Sign in to answer