Monday, March 19, 2012

Got a unicode error during copying database


I got following problems during copying database around different hosts.

Could anyone help me?

BR.
nathan

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12550
Date: 8/15/2007
Time: 2:53:51 AM
User: NT AUTHORITY\SYSTEM
Computer: DB1
Description:
Event Name: OnError
Message: ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unicode conversion failed".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
Operator: NT AUTHORITY\SYSTEM
Source Name: db_pushfun_com_DB1_Transfer Objects Task
Source ID: {939367C5-D98E-4C92-9688-9F32595DB981}
Execution ID: {09E39535-95E0-47EC-B49C-803B0986B1BB}
Start Time: 8/15/2007 2:53:51 AM
End Time: 8/15/2007 2:53:51 AM
Data Code: 0

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Well, I apologize if I am stating the obvious but it appears that you are trying to move a "Unicode" data type into a non-unicode target. Check your source and target databases for the data type of the fields. If they are different then you need to use the appropriate Type Case in a Data Conversion task to convert the source format to your target format.|||Actually, I'm copying a database not table. It's so strange that I could copy databases with unicode data from different hosts.

No comments:

Post a Comment