SQL Server Performance

import data from sybase table to sql2005 table using ssis

Discussion in 'SQL Server 2005 Integration Services' started by readit, Jun 22, 2009.

  1. readit New Member

    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 sybaseoledb 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.
  2. MohammedU New Member

Share This Page