This question should probably be in the Sybase area - but may be solved using M$ DTS -

I have a DB called WIN_I on a Server, that I do not have SA permissions on - I can't create a table anywhere on my destination server.

I need to take a table from a production Server, different DB, same table name ENFACT - and sync up one column.

If it was on M$ - the code might look like:
Update Server2.dbo.WIN_I.Enfact
Set MyColumn=(Select MyColumn from Server1.dbo.WIN_I.Enfact)
Where Server1.dbo.WIN_I.Enfact.ID=Server2.dbo.WIN.Enfact .ID

Since Sybase doesn't have a DTS - and M$ DTS doesn't like useing Parameters or Lookups when going between an ODBC connection - I went the route of unloading the ENFACT table from my source Server - thinking I could somehow BULK Import into a temp table and do my update - but that isn't working for me neither.

Any ideas anyone?

__________________
_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200