SSIS Toolbox Different on 2 Servers

Question

SSIS Toolbox Different on 2 Servers

homebrew01

SSC Guru

Points: 55539
More actions
November 6, 2018 at 2:20 pm

#368358

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

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

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

Phil Parkin SSC Guru Points: 246693 More actions · Answer 1

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

homebrew01 SSC Guru Points: 55539 More actions · Answer 2

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.

Phil Parkin SSC Guru Points: 246693 More actions · Answer 3

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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

homebrew01 SSC Guru Points: 55539 More actions · Answer 4

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 ?

Phil Parkin SSC Guru Points: 246693 More actions · Answer 5

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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

homebrew01 SSC Guru Points: 55539 More actions · Answer 6

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

Phil Parkin SSC Guru Points: 246693 More actions · Answer 7

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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.