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:
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?
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928††fax (360) 902-6200