Post reply

Problem in inserting data to sybase database from SSIS

  • January 15, 2009 at 1:08 am

    #126756

    Hi All

    I am getting the problem in connecting to Sybase database from SSIS Bulk Insert Task. The same is working fine with SQL Server.

    What exectly I need is I have a tab seperated text file and i want to save the data in the file to three different tables in Sybase database.

    Can anyone suggest the way to accomplish this task using SSIS.

    Thanks in advance !!!

    Amit

  • January 15, 2009 at 10:17 am

    #927515

    abansal (1/15/2009)

    Hi All

    I am getting the problem in connecting to Sybase database from SSIS Bulk Insert Task. The same is working fine with SQL Server.

    What exectly I need is I have a tab seperated text file and i want to save the data in the file to three different tables in Sybase database.

    Can anyone suggest the way to accomplish this task using SSIS.

    Thanks in advance !!!

    Amit

    SSIS Bulk Insert Task is designed only for SQL Server. Use the data flow task and standard OLE DB Destination component to accomplish your requirement.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply