I need guidance in creating SSIS package on SQL 2008 64 bit where the data source is Sybase. I'm new to SSIS package and not sure how I can accomplish following that I tried:
1-check if new data with today's date is available
2-if available --> archive destination table into archive table -->truncate destination table --> insert data from source table
3- if data is not available, retry after 1 hour
I've installed and configured sysbase drivers and a simple test package works from sybase to sql however, I'm not sure how can I query the data to check availability? Also, I'm not able to configure linked server through which I might be able to query sybase table.
I'd be very thankful for detailed response.