Geek asks and answers

Why is this SSIS package throwing conversion errors?

When I start, I get the following error:

Error during data flow [SQL Server Destination [164]]: The column "SepticSystemType" cannot be inserted because conversions between the DT_NTEXT and DT_WSTR types are not supported.

But according to this diagram, this right is legal:

http://msdn.microsoft.com/en-us/library/ms141704.aspx

Did I miss something?

+3
source share
2 answers

Here is a possible option. You can use the task Data Conversion Transformationavailable in the Data Flow Task to convert input from one data type to another. The following example shows how to do this.

Step by step:

  • dbo.DataNText dbo.DataUnicode, # 1 # 2.
  • . OLE DB soruce, OLE DB. # 6, , . NText - OLE DB; Conversion - ; Unicode - OLE DB.
  • NText dbo.DataNText. , # 3.
  • , 4. , . Copy of. Unicode String [DT_WSTR] 255. , .
  • dbo.DataUnicode. , # 5.
  • # 6.
  • # 7.

Derived Column Transformation.

, .

№1:

1

№2:

2

№3: ​​

3

№4:

4

№ 5:

5

№ 6:

6

№ 7:

7

+6

, DT_WSTR . ?

(DT_WSTR, 20) 20 20 DT_WSTR.

edit: . Siva .

+1

More articles:


All Articles