User SQL Service Broker to Pull data from Non SQL Server Database (Sybase ASA)

  • ramendravikram

    Valued Member

    Points: 69

    Hi Gurus,

    I am new to SQL Server Broker concept and would like to know if SQL Server Broker can help me pull data from Non SQL Server database and push it to SQL Server database.

    As i am just researching at this moment and don't spend much time, i though better to ask than re-inventing the wheel.

    Problem statement:

    I have a Sybase ASA database and i want to push some data to SQL Server database located centrally for some reporting purpose.

    Thanks in advance.

    Regards

    Ramendra

  • pietlinden

    SSC Guru

    Points: 62611

    Wouldn't you use Integration Services for that?

    Create a package that does what you want, and then create a schedule for it.

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

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