November 6, 2018 at 2:20 pm
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
November 6, 2018 at 4:32 pm
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
November 7, 2018 at 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.
November 7, 2018 at 8:22 am
homebrew01 - Wednesday, November 7, 2018 7:21 AMCozyRoc 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
November 8, 2018 at 9:48 am
Phil Parkin - Wednesday, November 7, 2018 8:22 AMhomebrew01 - Wednesday, November 7, 2018 7:21 AMCozyRoc 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 ?
November 8, 2018 at 10:43 am
homebrew01 - Thursday, November 8, 2018 9:48 AMPhil Parkin - Wednesday, November 7, 2018 8:22 AMhomebrew01 - Wednesday, November 7, 2018 7:21 AMCozyRoc 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
November 8, 2018 at 1:39 pm
CozyRoc wouldn't need to reside on the server running the SSIS package ?
November 9, 2018 at 5:34 am
homebrew01 - Thursday, November 8, 2018 1:39 PMCozyRoc 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