SSIS Initial Setup

Sakiru Dosumu - PeerSpot reviewer
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.


Deploying SSIS is straightforward, similar to other Microsoft products. You simply deploy the SSIS file and configure parameters as needed.
View full review »
Shubham-Agarwal - PeerSpot reviewer
Manager - Projects at Cognizant

The solution's setup was straightforward. It takes a day or two to complete the process. If you are good at development, the deployment process becomes easy. You only need a few resources to deploy the solution. I am handling deployment and maintenance all alone.

View full review »
BobAmy - PeerSpot reviewer
Sr. Architect - Data warehousing & BI at Molina Healthcare, Inc.

Installation is quite easy.  There are some drivers and setting you may need to make, based on the sources or sinks you need.  I am hoping these are more embedded in the install process, as I have not set up a server since 2015.

View full review »
Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.
Rohit Rastogi - PeerSpot reviewer
Lead Data Engineer at Capgemini

With SSIS, it is not difficult at all to set up. Many sources are there through which you can learn how to set up your SSIS. The documentation is great. With the help of documentation, it was very easy for me to set up.

Deploying a package would also not take a lot of time. It depends on what kind of package it is, however, it is pretty fast.  

View full review »
PALAK SURI - PeerSpot reviewer
Senior Software Engineer at Eurofins

The initial setup was easy, and we also used some YouTube videos for guidance. We use the latest version, and it is based on C Sharp.

View full review »
Krishna_Prasad - PeerSpot reviewer
Business Solutions Specialist at Kuwait Oil Company (K.S.C.)

The initial setup of this solution was very straightforward, and only took a couple of minutes.

View full review »
Arpita-Mishra - PeerSpot reviewer
Specialist Software Engineer at a financial services firm with 10,001+ employees

The initial setup is not difficult. However, when the volume increases, it slows down. It's a bit of an obsolete tech stack and is not very current.

You only need one person the setup and deploy the product. 

View full review »
Waqar Malik - PeerSpot reviewer
System Analyst at National University of Sciences and Technology

The efficiency of the deployment and management tools of SSIS is a bit technical, but it is alright since our company's technical support has hands-on experience with it, and they can deal with the deployment part in a very minimal amount of time.

The product's deployment phase is easy.

To deploy the product, I followed the solution's online tutorial and downloaded the tool to configure it.

View full review »
Eyal Golombek - PeerSpot reviewer
Database administrator at a recruiting/HR firm with 51-200 employees

The initial setup is very easy. I'd rate it an eight out of ten in terms of ease of implementation.

The deployment itself only took a couple of hours. 

The installation that comes with SQL just requires some tweaking with Visual Studio or something like that. We had some problems with maybe deploying the product from the local machine, however, in the end, we solved it.

We have three people handling the initial setup. All of us are DBAs.

View full review »
Business Intelligence Architect at a financial services firm with 5,001-10,000 employees

SSIS implementation has been straightforward for us, using scheduled tools like Kubernetes for deployment and master packages in SSIS. It seamlessly integrates with Microsoft products and other databases like Oracle or Teradata. We haven't faced issues integrating with third-party solutions, and even with tools like Attunity, it has worked reliably for almost a decade without performance problems.

View full review »
Mylsamy T. - PeerSpot reviewer
Senior Associate - IT at Himalaya Wellness Company

The first time I attempted to deploy the solution, it was a bit difficult. However, it gets easier with time. 

I'd rate the ease of setup 6.5 out of ten in terms of ease of implementation. 

I don't do much on the deployment side and, therefore, can't speak to how long it takes to actually deploy.

We have around eight people on the solution working on the deployment in total. Around 5 are database administrators and there are three developers. 

View full review »
Ullas Soman - PeerSpot reviewer
DevOps Consultant at Coforge Growth Agency

The solution is very straightforward. It's not overly complex. 

The package deployment takes some time. It depends on the size of the data which is being pulled in. For the normal setup, it hardly takes much time. For the most part, it is very fast.

View full review »
Syed Fahad Anwar - PeerSpot reviewer
Principal System Developer at HHRC

The initial setup isn't too difficult, but it's not easy. Sometimes, you may need help from a database administrator to set up the SQL Server Integration Services. It can take almost a day to deploy. 

A database administrator can deploy it alone. You may need another person to develop the packages and set up ETL, so it's you need about two or three people for deployment in all. 

View full review »
DM
Data Architect at AMP Capital

I've never had to install SSIS at an enterprise level, but the installation is straightforward for development purposes. It takes less than an hour. However, installing it at the enterprise level would require a lot more configuration, tuning, etc. I'll leave that to the experts.

View full review »
VS
Senior Associate at PwC Acceleration Centers

The initial setup of SSIS is easy. The full deployment took approximately one hour.

View full review »
SR
IT Manager at European University

How easy or difficult the setup is depends on the size of the process that we want to normalize. If it is a big ETL, it's not always that fast. We are considering changing to a different platform so that it's easier. For example, we are looking into SQL to have another kind of data exploration.

The first time we initially set it up, it was quite fast. The deployment of the integration services for the very first time without any process implemented took about a day.

View full review »
Kerols Alfons - PeerSpot reviewer
Lead Software Engineer at WadiDegla

The initial setup of SSIS is easy.

I rate the initial setup of SSIS a five out of five.

View full review »
AS
General Manager IT at a manufacturing company with 10,001+ employees

The initial setup is straightforward.

View full review »
LD
IT Project Management /Research & Development Team Leader at Ethiopian Roads Administration

The solution is straightforward and simple. It's not overly complex or difficult. It's actually quite easy for us to get everything up and running. We can finalize everything within a day. It doesn't take a lot of time to implement it. 

One person is enough to deploy and maintain the solution. That said, it depends on an organization's planning strategy. It might not take a lot to do that kind of activity.

View full review »
SB
Admin at IEC (Electoral Commission of South Africa)

Installing SSIS is straightforward and takes an hour or two.

View full review »
TY
Technical Consultant at LinkDev

The solution is straightforward to set up. It's not overly complex. It takes about half an hour to set up.

We have five people that can handle deployment or maintenance tasks. 

View full review »
Dhruv Singh - PeerSpot reviewer
Senior Architect (Data and AI) at a tech services company with 1,001-5,000 employees

The initial setup was pretty simple. To install the SQL Server, select the feature during installation on the same server. In the case of a separate server, opt for SSIS service installation instead of installing the SQL Server, and it will be pretty quick. You can have your server up and running within ten minutes.

View full review »
ArturKowalczyk - PeerSpot reviewer
Technology Innovation Leader at Netrix S.A.

The initial setup is straightforward.

It only took five minutes to deploy SSIS. 

For maintenance, we rely on our platform team.

We will probably need one person for maintenance. Let's say it's only one person. But I'm not speaking on behalf of the entire company; I'm speaking on behalf of a single team of perhaps 1,000 people.

View full review »
YY
Manager, Data & Intelligence Group, Technical at a consultancy with 10,001+ employees

The initial setup is straightforward. The deployment took a day and we did it in-house. 

View full review »
Anil Jha - PeerSpot reviewer
Director D&A at Iris Software Inc.

The initial setup is straightforward and is not complex. It took about a day to install.

You would need two to three technical staff for the deployment and maintenance of the solution.

View full review »
EL
BI Architect at a retailer with 10,001+ employees

Absolutely, the initial setup is a simple process. In my opinion, it's easy.

SSIS doesn't require any maintenance.

View full review »
Elena Tejadillos - PeerSpot reviewer
IT Officer in Data Science at United Nations

The initial setup of this solution is quite simple.

View full review »
AN
CEO at Shiraz University

The initial setup was very easy for us and very good.

View full review »
AltanAtabarut - PeerSpot reviewer
Solution Consulting, Growth, Analytics at Akinon

The initial setup was easy.

View full review »
XZ
Integration developer at Blackwoods

The setup was easy. All Microsoft products are easy to set up. 

View full review »
Pavan Yogender - PeerSpot reviewer
Founder and CEO at Zertain

The solution's initial setup is easy, but you'd need expert-level knowledge to work on it.

View full review »
BillyJohn - PeerSpot reviewer
Data Engineer at DataHyv

Setting up SSIS is difficult. I rate it seven out of 10 for ease of setup. It takes around a week to setup a simple data warehouse with three tables. 

View full review »
Vichitra Mohan - PeerSpot reviewer
Technical Service Team Manager at a tech vendor with 10,001+ employees

The initial setup was pretty simple.

View full review »
MJ
Senior Manager Software Development at Techlogix

Its setup is very easy. You don't need too many components to start building ETL tools. Plus, there are a lot of online learning available for this tool. It can be deployed on any Windows machine with minimal requirements.

View full review »
IL
Data Engineer at a tech services company with 11-50 employees

Its installation wasn't my job. We have a team that specializes in infrastructure, and they install and set up the tool. When I was a student, I used to install it myself, and it wasn't really difficult, but I have not installed it on a professional site or for a company. 

View full review »
MG
Technical Product Owner, Team Lead at ARCA

The setup is straightforward. It's very easy to install.

View full review »
SP
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 »
BD
Business Process and Strategy Specialist Advisor at NTTData

Never participated in the initial setup.

View full review »
MP
Senior Analyst at a tech services company with 1,001-5,000 employees

The initial setup is never a complex process because the interface is user-friendly. If you are working with complex situations, then it can get complicated. We have a DBA team to handle the deployment. We must follow a process to deploy, so we need to get approval whenever there is a change. It's not easy for us, but it's still good, and it doesn't take much time. 

View full review »
IS
Director at Netica d.o.o.

The initial setup was straightforward.

View full review »
Lucas Dreyer - PeerSpot reviewer
Data Engineer at BBD

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 »
CG
BI Consultant at a tech services company with 201-500 employees

The installation was easy.

View full review »
it_user342606 - PeerSpot reviewer
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 »
Edgar Talom - PeerSpot reviewer
Information Technology Support Engineer/ Implementation Analyst /DBA at a tech services company with 11-50 employees

Setting up SSIS is complex, and if you misconfigure something, you'll have problems during migration. I rate SSIS six out of 10 for ease of setup.

View full review »
AS
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 »
SA
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 »
it_user1048011 - PeerSpot reviewer
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 »
it_user102120 - PeerSpot reviewer
Business Intelligence Consultant at a tech services company with 51-200 employees

It's easy to deploy, you just need a simple file-copy mechanism that is sufficient for most deployment scenarios.

View full review »
Celine Meesseman - PeerSpot reviewer
Director at Ingenia

It's easy to install and create the first flow.

View full review »
Shivani Pandey - PeerSpot reviewer
Consultant at Veear Analytics pvt limited

I found the setup comparatively easy. Within a day, anybody can start using it. Two or three people are more than enough for deployment and maintenance. 

View full review »
Serdar Erdurak - PeerSpot reviewer
Information Zone Leader at digitallency

The initial setup of this solution is not complex. 

View full review »
RH
Assistant Manager at a tech services company with 10,001+ employees

The setup is straightforward.

View full review »
KS
Owner at 7Spring Consult

The initial setup was simple and straightforward.

View full review »
JF
BI Consultant at a tech services company with 201-500 employees

The initial setup was straightforward.

View full review »
Alexander Samuel Larico - PeerSpot reviewer
Teaching Professional at Next Idea Lab

The initial setup is easy, and we did not find it complex.

View full review »
ST
Software Developer at a transportation company with 1,001-5,000 employees

The initial setup was complex. 

View full review »
Buyer's Guide
SSIS
March 2024
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,847 professionals have used our research since 2012.