SSIS Initial Setup

SeniorBI67
Senior BI Developer at a music company with 501-1,000 employees
The initial setup of this solution is part of the DBA's role, and I did not involve myself in this installation. However, I have done it before. To set up a SysTD is pretty straightforward, and it can be configured to your own company ETL framework. The length of time required for deployment depends on how good your DBAs are. Some of them take quite a while because they have to install, configure, and then do some test runs. Then all of the permissions, etc, have to be taken care of. Some of these things are easy and some of them are difficult. I would say that it will take a least a week. We have five people maintain this solution at the moment. We have the DBAs on standby before we do any sort of deployment to UAT or production. View full review »
reviewer860583
Data Scientist at a tech vendor with 501-1,000 employees
The initial setup of this solution is pretty much straightforward. If you want to develop with Visual Studio then you have to install the data service add-ons afterward, so it is a bit cumbersome. Then, if you want to use the catalog on the database, with deployment there are often security issues and you have to get an SQL catalog up and running. This can also be a bit cumbersome. I would say that it takes a day or two to deploy this solution in a new environment, and it can be completed by one or two people. A single developer may be sufficient to deploy and maintain the system. View full review »
AhmedShaban
Database Consultant
The initial setup of the solution was easy. Deployment took less than two hours. You only need one person to implement and maintain it. At the same time, we do have another person who monitors the server-side. View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: March 2020.
406,860 professionals have used our research since 2012.
Alireza Nikseresht
CEO at Shiraz University
The initial setup was very easy for us and very good. View full review »
Globalmark677
Platform Lead: Global Markets Data Analytics at Rand Merchant Bank
The initial setup was straightforward. We've got quite a strong SQL experience in my team. We have about five people working on the solution, including Data engineers and BI developers. They're all admins. View full review »
AltanAtabarut
Founding Partner at Altdata Analytics
The initial setup was easy. View full review »
Sherif Abdelrehim
Data Architect and Modeler at a tech services company with 201-500 employees
The initial setup of this solution is very straightforward. In a few hours, everything was up and running. View full review »
BIConsule1f7
BI Consultant at a tech services company with 201-500 employees
The initial setup was straightforward. View full review »
Brian Dandeneau
Lead Consultant at Applied Governance
Never participated in the initial setup. View full review »
Prodown567
Technical Product Owner, Team Lead at ARCA
The setup is straightforward. It's very easy to install. View full review »
Sasidhar Parupudi
Principle Consultant at Keyrus South Africa
The initial setup is straightforward. Deployment is done by another team. I download the package and deliver it to them and they deploy it onto the cloud. In terms of maintenance, we only need one person. View full review »
KirillSlivchikov
Executive Director and Co-Founder at 7Spring Consult
The initial setup was simple and straightforward. View full review »
Igor Smirnov
Director at Netica d.o.o.
The initial setup was straightforward. View full review »
DevoSft67
Software Developer at a transportation company with 1,001-5,000 employees
The initial setup was complex. View full review »
reviewer789228
BI and Report Development Technician at a tech vendor with 201-500 employees
The initial setup of this solution is quite simple. View full review »
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration Tools. Updated: March 2020.
406,860 professionals have used our research since 2012.