We changed our name from IT Central Station: Here's why

SSIS Primary Use Case

Senior Manager Software Development at Techlogix

We have used SSIS in many ways. Primarily, it has been used for building ETLs for populating data warehouse and staging areas. We have developed a number of data marts that were populated. We build data migration packages, which have been reused a number of times with minimal configurations. Additionally, we build complex data integrations solutions and data hand-offs between different applications. We have even used it for creating and parsing SWIFT messages for data integration purposes. We also used it for email triggers. 

Now SSIS has introduced Big Data and cloud components. Though we haven't used any of these yet but it's really a very good addition to enhance SSIS capabilities.

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

We are using it in our company and for our clients. I have experience in working with the whole data cycle, which includes data collection, transformation, and visualization. I have worked with the end-to-end process, and I have handled data integration, analysis, and visualization.

I specialize in Microsoft tools, and I have used SSIS for data integration and Power BI for data visualization. I have also worked with Tableau for data visualization and Talend for data integration.

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

We primarily use SSIS to collect data from one system and transfer it to another.

The Classical ETL processing of data.

View full review »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
564,322 professionals have used our research since 2012.
MP
Senior Analyst at a tech services company with 1,001-5,000 employees

We have data that needs to be migrated. There is also a scan inventory. We create web data, pull it, search it, and then find answers and report stakeholders. So for this process, we use the SSIS.

View full review »
AL
Teaching Professional at a tech services company with 1-10 employees

We are a software development company and implement solutions like SQL Server SSIS for our clients. We do not use this product ourselves in the company but have experience with it because our client asked for it.

Our clients use it to transform data and generate reports. The use cases are generally simple, and not advanced or complex.

View full review »
MB
Project Lead Performance Engineer & Automation at a insurance company with 10,001+ employees

We are using SSIS for all of our relational database management systems (RDBMS) data.

View full review »
Learn what your peers think about SSIS. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
564,322 professionals have used our research since 2012.