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 (let's call this source server
Server1), that I do not have SA permissions on - I can't create a table
anywhere on my destination server (call it Server2).

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

If it was on M$ SQL - 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 using 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

MS Sql Server LazyDBA home page