for creating SSIS packages u need to install SQL Server 2005/2008/2008 R2 which has BIDS(Business Intelligence) inbuilt.... for connecting to sybase use OLEDB connection manager from SSIS packages......

If you want to delete the whole table use truncate stmt which has very minimal transactional logging.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

IMPORT FROM EXCEL TO TABLE

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Select * into XLSheet1 from OPENROWSET ('Microsoft.jet.OLEDB.4.0','Excel 8.0;

database=C:\Latest.xls;',

'Select * from [Report$]')

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

EXPORT FROM TABLE TO EXCEL

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

INSERT INTO OPENROWSET ('Microsoft.jet.OLEDB.4.0','Excel 8.0;

database=C:\Latest.xls;',

'Select * from [Report$]')

select top 10...