SSIS Toolbox Different on 2 Servers

  • I have 2 servers running SQL 2016, but 1 server seems to have "Lost" toolbox items that were there before. I just downloaded SQL Data Tools 2017 onto both, hoping that would resolve it.

    Also getting piles of errors on Server 2 when opening existing packages that were developed there.

    Am I missing some simple setting somewhere on server # 2 ??

    Server # 1 Toolbox

    Server # 2 Toolbox

    Server # 2

  • Some third party SSIS extensions are installed on server 1. Cozyroc or something like that.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • CozyRoc has been running on Server 2, and looks like it's still installed. So server 2 should have everything or more than server 1.

    I'll contact CozyRoc, see what they think.

  • homebrew01 - Wednesday, November 7, 2018 7:21 AM

    CozyRoc has been running on Server 2, and looks like it's still installed. So server 2 should have everything or more than server 1.

    I'll contact CozyRoc, see what they think.

    There should be no need at all to install SSDT on your database servers. Keep them clean.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Phil Parkin - Wednesday, November 7, 2018 8:22 AM

    homebrew01 - Wednesday, November 7, 2018 7:21 AM

    CozyRoc has been running on Server 2, and looks like it's still installed. So server 2 should have everything or more than server 1.

    I'll contact CozyRoc, see what they think.

    There should be no need at all to install SSDT on your database servers. Keep them clean.

    What do you suggest ?

  • homebrew01 - Thursday, November 8, 2018 9:48 AM

    Phil Parkin - Wednesday, November 7, 2018 8:22 AM

    homebrew01 - Wednesday, November 7, 2018 7:21 AM

    CozyRoc has been running on Server 2, and looks like it's still installed. So server 2 should have everything or more than server 1.

    I'll contact CozyRoc, see what they think.

    There should be no need at all to install SSDT on your database servers. Keep them clean.

    What do you suggest ?

    Development on local machines, then deploy to server.
    Cozyroc can be installed locally at no charge, and run in SSDT.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • CozyRoc wouldn't need to reside on the server running the SSIS package ?

  • homebrew01 - Thursday, November 8, 2018 1:39 PM

    CozyRoc wouldn't need to reside on the server running the SSIS package ?

    Cozyroc needs to be installed wherever packages containing Cozyroc components are designed or run.

    However, it only needs to be licensed on machines which run packages on a schedule, eg, as SQL Agent jobs ... generally these would be your non-development machines.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 8 posts - 1 through 7 (of 7 total)

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