Driver Not Capable Error

[Database Administrator]

I am trying to set up a DTS Package to copy data from a BMC Action Request
(Remedy) Database to an SQL Database. I have done the following

1. Set up an ODBC Connection to the Remedy Database using (Other ODBC Data
Source) and specifying a System DSN
2. Set up a connection to my SQL Server using Microsoft OLE DB Provider for
SQL Server
3. Created a Transform Data Task to copy the Data

When I try to execute the DTS Package I get a 'Driver Not Capable' error.

If I use the same DSN in Excel it returns the Data OK.

Does anyone have any ideas?

Thanks in advance

Andy W