Sorry if this is in the wrong forum.
I am trying to use OpenLink Lite for Progress 8.3e (Large Client) to pull our qad databases into sql server. I am having a problem pulling the usrw_wklf table. SQL Server sees all the user defined fields being 8 characters long, when I know they are not.
I asked our Progress programmers how they see more than 8 characters from these fields and they sent me a code snipit.
usrw_CHARFLD[13] format "x(32)"
when I try to put this same code in my dts package on the source query I get the following error:
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: [OpenLink][ODBC][Progress Server]** Unable to understand after -- "DECLARE". (247)
I have been searching all day for a solution for pulling all 32 characters into my SQL Server.
Thanks in advance for any help.
I am trying to use OpenLink Lite for Progress 8.3e (Large Client) to pull our qad databases into sql server. I am having a problem pulling the usrw_wklf table. SQL Server sees all the user defined fields being 8 characters long, when I know they are not.
I asked our Progress programmers how they see more than 8 characters from these fields and they sent me a code snipit.
usrw_CHARFLD[13] format "x(32)"
when I try to put this same code in my dts package on the source query I get the following error:
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: [OpenLink][ODBC][Progress Server]** Unable to understand after -- "DECLARE". (247)
I have been searching all day for a solution for pulling all 32 characters into my SQL Server.
Thanks in advance for any help.