DSXchange

I'm trying to import metadata from SQLServer 2000 into DataStage when the following error occurs. Anyone have a clue what this is?

DSR.MetaGeta(GET.FOREIGNKEYS)(SQLForeignKeys): BCI Error:
SQLSTATE=37000,CODE=7202,[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'BiogenixV4' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

Thanks.

Welcome aboard. :D

This is an issue with the way access to SQL Server has been set up. As the error message says, there is no entry for BiogenixV4 in sysservers. Get your SQL Server DBA to assist with the sp_addlinkedserver stored procedure which can add the entry.