I have a DW that is currently running on a Linux platform with Sybase ASE.  The database is used for reporting.  The transactions are handled by a mainframe that; sends the DW an empty text file so it know it's time to download a group of tables from the mainframe, biulds a zipped version of a data file for each table in the group).  The files are ftp'd down, go through pre-processing (truncating tables, dropping indexes, stopping user queries, etc if applicable),  load (bcp) and post processing (adjust data, build/update inedexes, etc if applicable).  This is handled by scripting (bash, korn, etc).

I've been able to convert the data succesfully via SSMA but now I need to know where to start to handle the data updates as described above.  Which tools, etc should I start with?

Thanks,

Bob

I would automate this with SQLCMD. You can build and test most of this in SSMS when it is set to SQLCMD mode, and then save them as SQLCMD files, and run them as CRON joms on Windows Scheduler. There should be few differences between Sybase and SQL Server for the scripting, as most of the grunt work is done with BCP and DBCC which originate with Sybase.