Hello:
I am trying to just copy a table from sql server 8.0 to UDB.
The table is simple, 3 columns, as listed here:
[Field1] [decimal](4, 0) NOT NULL ,
[Field2] [int] NOT NULL ,
[Field3] [decimal](3, 0) NULL
The table in UDB is identical.
The transformation is just a straight Copy Column...nothing fancy.
When I run the package this is what I get:
Error at Destination for Row number 1. Errors encountered so far in this
task: 1.

Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:[IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00

Any help is greatly appreciated.

Joe

Initially I suggest you have a search on IBM's site and ensure you have the
latest ODBC driver.

To circumvent the problem why not BCP or DTS the data out into a CSV file.
Then import the file on UDB using there data import method

--
HTH
Ryan Waight, MCDBA, MCSE

"Joe Linares" <linaresNOj (AT) aetna (DOT) SPAMcom> wrote