Hi,
I want to extract data from sql server to sybase. For us source db is sql server and we own Sybase db. So I dont want use DTS package or SSIS for this data loading.
My manager asked me to limit changes on source side. So he asked me to script run a file save the results to text file and then load in to our sybase server.
Does any one know how to do this ?
I am thinking to use bcp option and isql utility . Before using bcp I need to run select statements which has joins and save the results to a text file and then bcp to our sybase server.