Post reply

Querying msdb from SSIS Execute SQL Task

  • February 12, 2014 at 11:09 pm

    #1688602

    I tried to reproduce this but was not able to do so. Though you have mentioned it but could you please confirm once again that it works in SSMS with SQL authentication under same user context. And also there isn't any expression used for the conn mgr and no config as well .

  • February 13, 2014 at 8:06 am

    #1688757

    Thanks very much for your response, and yes it works in SQL Server Management Studio with SQL authentication under same user and context. I haven't used any expression or config file on the connection manager.

    Just to clarify did you get it to work in both SSIS as well as SSMS using SQL authentication?

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

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