Post reply

SSIS project connection manager

  • December 2, 2014 at 2:54 am

    #292983

    We have some SSIS Packages which use a project level connection manager. Obviously if we schedule a single package from this project to run via a Job, it will fail as the connection manager is not in the package.

    Is there a way to use project connection managers and schedule jobs? How can this be achieved

  • December 2, 2014 at 3:07 am

    #1761975

    SQLAssAS (12/2/2014)

    We have some SSIS Packages which use a project level connection manager. Obviously if we schedule a single package from this project to run via a Job, it will fail as the connection manager is not in the package.

    Is there a way to use project connection managers and schedule jobs? How can this be achieved

    You need to deploy the project to the SSIS catalog, since you are using the project deployment model.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 2, 2014 at 3:59 am

    #1761991

    Thanks - just going through the set up of the catalog. It looks like this method uses CLR. Whats your view on that? Is this safe to use \ seen as best practise?

  • December 2, 2014 at 4:16 am

    #1761994

    SQLAssAS (12/2/2014)

    Thanks - just going through the set up of the catalog. It looks like this method uses CLR. Whats your view on that? Is this safe to use \ seen as best practise?

    It uses CLR behind the scenes. You don't have any influence on that.

    If you don't like it, too bad, no catalog for you 🙂

    Haven't encountered any issues with it (yet), to be honest.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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