Post reply

SSIS/SSRS connection to Intersystems Cache

  • April 27, 2011 at 1:33 pm

    #238675

    I'm looking for any pointers on accessing VMS data that is overlaid with CACHE. I'd like to use SSRS for reporting. I've found a couple of articles that refer to Linked Servers and ODBC connections, but none give real details. Any pointers, other that getting rid of VMS, are appreciated.

  • April 28, 2011 at 7:53 am

    #1317268

    sgs-930137 (4/27/2011)

    I'm looking for any pointers on accessing VMS data that is overlaid with CACHE. I'd like to use SSRS for reporting. I've found a couple of articles that refer to Linked Servers and ODBC connections, but none give real details. Any pointers, other that getting rid of VMS, are appreciated.

    Hi,

    You have to use ADO.NET Source component with your ODBC connection to retrieve data in SSIS.

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