SEO

#1 (**permalink**) 02-27-2008, 08:16 PM

Hi All,

I am using OpenLink's ODBC in order to transfer data from Progress Data
Server into the SQL.
When trying to transfer a field which has a character format on the
Progress Server, the DTS transfer only the first 8 characters of this
field.
The format of the field in the progress database is "x(8)" although it
contains more charactres (8 chars is only view format)
Any idea how to overcome this problem?

Thanks,
Ofer

#2 (**permalink**) 02-27-2008, 08:16 PM

I'm not familiar with Progress Data Server (or character formats on
columns), but it sounds like one of two things are happening:

1. The OpenLink ODBC driver is returning the correct max-length of the
column, but is only returning the first 8 characters to DTS, which therefore
can only transfer those first 8 characters. If DTS created the table in SQL
Server, then you can check the max-length of the created column to see if
DTS was given the correct max-length information.

2. The OpenLink ODBC driver is returning the wrong max-length (8) of the
column, so DTS will only transfer a maximum of 8 characters to SQL Server.
If the target column in SQL Server has a max-length of 8, then this is
likely what is happening.

Either way, it sounds like a problem with the ODBC driver. Maybe you can
configure it to ignore character formatting on columns?

Brannon

"Ofer" <ocohen@visonic.com> wrote in message
news:cgce95$i80@odah37.prod.google.com...
> Hi All,
>
> I am using OpenLink's ODBC in order to transfer data from Progress Data
> Server into the SQL.
> When trying to transfer a field which has a character format on the
> Progress Server, the DTS transfer only the first 8 characters of this
> field.
> The format of the field in the progress database is "x(8)" although it
> contains more charactres (8 chars is only view format)
> Any idea how to overcome this problem?
>
> Thanks,
> Ofer
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Transfer data from progress to SQL, character field format