Hi All
I am trying to import data from sybase to sql2005 by using ssis. But while establishing the source connection as oledb for sybase i am facing error like login time expired. I tried with the odbc in new connection but the table from sybase is not fetching.
Moreoevr it shows an error .ids file was not created in the \sybase\oledb\ folder.
Actually i am able to be establish the odbc connection without any issues. But only when i try connecting the sybase through oledb provider i ma getting the error. Moreover i tried creating the linked server but no luck.
I checked the sybase port and user access it is fine.
Is there any steps to import data from a particular database table from sybase to sql 2005? If so please let me know.
I am trying through ssis.
Thanks in advance
i forgot to add one more point i tried importing the sybase data to sql 2005 by using dts it worked. Whereas i am not able to do the same by using ssis. Please advise.