SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS Toolbox Different on 2 Servers


SSIS Toolbox Different on 2 Servers

Author
Message
homebrew01
homebrew01
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49425 Visits: 9278
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





Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217144 Visits: 24921
Some third party SSIS extensions are installed on server 1. Cozyroc or something like that.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
homebrew01
homebrew01
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49425 Visits: 9278
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
Phil Parkin
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217144 Visits: 24921
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
homebrew01
homebrew01
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49425 Visits: 9278
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
Phil Parkin
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217144 Visits: 24921
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
homebrew01
homebrew01
SSC-Forever
SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)SSC-Forever (49K reputation)

Group: General Forum Members
Points: 49425 Visits: 9278
CozyRoc wouldn't need to reside on the server running the SSIS package ?



Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)SSC Guru (217K reputation)

Group: General Forum Members
Points: 217144 Visits: 24921
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search