Post reply

Destination task for Access db in Data Flow task

  • July 4, 2008 at 5:25 am

    #122316

    Hi all,

    Here I have requirement that I have to take data from two different tables in SQL Server and need to populate the same data into a Access database table.

    I have taken connections as

    OLEDB connection for SQL Server

    ODBC connection for Access database

    I used the Data flow task

    OLEDB Source -> I have a query that pull the data from two tables based on condition

    Destination: which destination task I have to take here to populate the data coming from the OLEDB Source task?

    Thank You

  • July 8, 2008 at 12:50 am

    #839286

    Could some one help me out please...?

    Thank You

  • July 8, 2008 at 5:07 am

    #839372

    Hi Venki,

    Why don't you connect to your access database using OLE DB for Jet?

    Then you can use the OLE DB Destination.

    ODBC destination is not supported in SSIS. That is to say that there are no out-of-the-box components. However if you really had to use ODBC, you could code a destination using the script component.

    See books online or MSDN forums for examples.

    Kindest Regards,

    Frank Bazan

  • July 8, 2008 at 9:26 am

    #839561

    Thanks a lot Frank. Now it is working:)

    Thank You

Viewing 4 posts - 1 through 3 (of 3 total)

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