Import PostgresSQL dump into SQL Server - data type errors -


i have data dumped postgressql database (allegedly, using pg_dump) needs imported sql server.
while data types ok, running issue there seems placeholder null. see backslash followed uppercase n in many fields. below snippet of data, viewed within excel. left column has boolean data type, , right 1 has integer data type

snippet of data, viewed within excel. left column has boolean data type, , right 1 has integer data type

some of these supposed of boolean datatype, , having 2 characters in there not going fly.

here's tried far:

  1. import via dirty read - keeping whatever datatypes ssis decided each field had; no avail. there error messages truncation on of boolean fields.
  2. creating table data based on correct data types, though more fun... needed same in dirty read, source otherwise not load properly. there need transform data correct data type insertion destination data source; yet, getting truncation issues, when shouldn't be.
    here sample expression in derived column transformation editor:
    (dt_bool)replace(observation,"\\n","")
    data type should boolean.

any suggestion helpful!

thanks!

since unable circumvent ssis rules in order data tables without error, took quick-and-dirty approach.
solution worked me have source data read each column if string, , destination table had fields of datatype varchar. destination table used staging table, once in ss, can manipulate needed.

thank @cha input.


Comments