Data type is Text not working

More
1 year 4 months ago #13903 by witch
Data type is Text not working
I use PGNP for transfer data from Postgres to other Postgres by SSIS Wizard (MSSQL 2012)
but data type is text have problem. data is incomplete

Please Log in or Create an account to join the conversation.

More
1 year 3 months ago #13906 by Moderator
This issue occurred because the OLEDB provider could not recognize single/wide characters in ISequentialStream. The solution was introduced in build 3442 (see STREAM connection string parameter description in the Developer's Manual).

Before build 3442 there was a workaround: insert hint statement "CREATE TABLE IF NOT EXISTS tbl (col1 ntext)" in the beginning of the SSIS task. The statement gives "hint" to the OLEDB provider that incoming ISequentialStream will contain wide characters. The word "ntext" is crucial.

Starting with 3442, connection string parameter STREAM and the hint could be used together. The parameter defines default interpretation.

Please Log in or Create an account to join the conversation.

Time to create page: 0.134 seconds
Powered by Kunena Forum