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

• ramendravikram

  SSC Journeyman

  Points: 99

  More actions

  September 30, 2015 at 12:09 am

  #321627

  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: 63506

  More actions

  September 30, 2015 at 12:40 am

  #1830337

  Wouldn't you use Integration Services for that?

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