Hi All,

I download Microsoft OLEDB Provider for DB and use it in SSIS to connect to
DB2.now I meet a problem that is I can't transfer Nvarchar datatype from SQL
Server 2005 to DB2.error is:

SSIS package "Unicode02.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is
beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is
beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute
phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase
is beginning.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is
beginning.
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [16]: An OLE DB
error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft DB2 OLE DB Provider"
Hresult: 0x80040E14 Description: "The value of input host variable or
parameter number "" cannot be used because of its data type. SQLSTATE:
07006, SQLCODE: -301".
Error: 0xC0209029 at Data Flow Task, OLE DB Destination [16]: The "input
"OLE DB Destination Input" (29)" failed because error code 0xC020907B
occurred, and the error row disposition on "input "OLE DB Destination Input"
(29)" specifies failure on error. An error occurred on the specified object
of the specified component.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method
on component "OLE DB Destination" (16) failed with error code 0xC0209029.
The identified component returned an error from the ProcessInput method. The
error is specific to the component, but the error is fatal and will cause
the Data Flow task to stop running.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has
exited with error code 0xC0209029.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase
is beginning.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is
beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB
Destination" (16)" wrote 0 rows.
Task failed: Data Flow Task
Warning: 0x80019002 at Unicode02: The Execution method succeeded, but the
number of errors raised (4) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Unicode02.dtsx" finished: Failure.

It would be appreciated if someone can give me some comment.

BTW:I notice that I need to use CAST to change Varchar's(include char) page
code if the SQL Server source and the DB2 destination have the different
page code.

Best Regards,
David