TrustRadius: an HG Insights company

Notepad++ vs. SQL Server Integration Services (SSIS) vs. Sublime Text

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Notepad++

    Score9.2 out of 10
    N/ANotepad++ is a popular free and open source text editor available under the GPL license, featuring syntax highlighting and folding, auto-complete, multi-document management, and ac customizable GUI.N/A

    SSIS

    Score8 out of 10
    N/AMicrosoft's SQL Server Integration Services (SSIS) is a data integration solution.N/A

    Sublime Text

    Score8.8 out of 10
    N/ASublime Text is a highly customizable text editing solution featuring advanced API, Goto functions, and other features, from Sublime HQ in Sydney.

    $80

    Pricing
    Notepad++SSISSublime Text
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Business
    $80.00
    Offerings
    Pricing Offerings
    Notepad++SSISSublime Text
    Free Trial
    NoNoNo
    Free/Freemium Version
    NoNoYes
    Premium Consulting/Integration Services
    NoNoNo
    Entry-level Setup FeeNo setup feeNo setup feeNo setup fee
    Additional Details———
    More Pricing Information
    Community Pulse
    Notepad++SSISSublime Text
    Considered Multiple Products
    Open Source
    Chose Notepad++
    Notepad++ has a simple GUI.
    I use it when needed to take quick notes or come up with a rough logic to any problem.
    Even though Sublime Text is a lot sleekier tha Notepad++, the search capabilities of Notepad++ makes it a winner.
    Incentivized
    Chose Notepad++
    Atom is a nice little notepad and editor, but it's a bit overkill for a simple note-taking app and doesn't quite compare to Visual Studio Code for more robust tasks like software development. It does have more polish than Notepad++, but the experience is somehow more clumsy. Sub…
    Incentivized
    Chose Notepad++
    I used to use Sublime Text for text editing because at the time I liked the ability to apply themes to the interface and I appreciated the text color coding. However, several years ago something happened one time while I was using Sublime Text (unfortunately, it's been too long …
    Incentivized
    Chose Notepad++
    I haven't used a lot of other editors that are similar to Notepad++ aside from Sublime Text. Although I do like the interface of Sublime Text, I did not like how it was dependent on learning and memorizing a lot of hotkeys and commands. I like that Notepad++ has a rich, …
    Incentivized
    Chose Notepad++
    In comparison to applications like Sublime Text or Visual Studio Code, Notepad++ is very limited. But this one has a different use. It's not used to work on projects—more like just editing and converting single files. It's the advanced version of the default Windows notepad. …
    Incentivized
    Chose Notepad++
    I mainly use Notepad++ on windows. EditPlus was very good at regular expressions. I felt it was better than Notepad++. On Mac, sublime is a good tool for the same purpose.
    Incentivized
    Chose Notepad++
    It's free. Very easy to use. Can be used for a number of languages.
    Incentivized
    Chose Notepad++
    Notepad++ is much easier to use due to its light UI and gradual learning curve. It also supports third-party plugins using which certain additional features can be added.
    Incentivized
    Chose Notepad++
    Notepad ++ has been easier to use, configure and maintain the other offerings. We prefer the lightweight install and configuration to Office. This is especially helpful on servers where we do not want overhead on. The configuration and ease of use right out of the gate is …
    Incentivized
    Chose Notepad++
    Notepad++ is free, entirely, so you're not going to have to pay for more features (like with Sublime). It's also available offline, so if you're having internet issues you won't lose your data (like with Evernote).
    Incentivized
    Chose Notepad++
    Notepad++ is easy to use. If you have used notepad it's a more advanced version of it. It has a lot of themes and plugins which you can download from the community page and are free. It's easier to build applications in Notepad ++ as it works with various environments. It helps …
    Incentivized
    Chose Notepad++
    We actually don't use Notepad++ over any other software, but in tandem with it. It complements other more advanced, modern text editors and definitely provides a lightweight way to edit code files, especially ones that are interpreted like Python, without having to open a full …
    Incentivized
    Chose Notepad++
    Others in my organization use Sublime and like it. However, it must be purchased. I have not used it enough to have an opinion on which is better. Obviously, I have used Windows Notepad in a pinch, and this is so much better so it's really not even a valid comparison.
    Incentivized
    Chose Notepad++
    Notepad++ is by far the best text editor I have ever tried. You really don't need to look elsewhere as far as functionality and convenience. I wouldn't really write long hand code in it. I'd rather use something like Dreamweaver because it's built just to write code and has …
    Incentivized
    Microsoft
    No answer on this topic
    Sublime HQ
    Chose Sublime Text
    Sublimes text is comparable with the Microsoft Visual Studio Code and NotePad++. However, VS code is far better than [Sublime Text] in terms of the plugins and extensions available in the market. [...] Sublime consumes [...] less memory, compared to the VS code, [which …
    Incentivized
    Chose Sublime Text
    Easier to use, runs very solid (especially on Mac OS). Syntax coloring is the best. Possibilities to add plugins and custom things is huge. Connection with Github works great (never tested this with the other tools though).

    Also, our company has chosen this tool so at my current …
    Incentivized
    Chose Sublime Text
    Sublime Text is free and offers a cleaner coding interface. Even if I forgot to save updates to a file, the next time I open it, it's still present. Sublime Text boots faster than the other text editors and is also easy to deploy. Memory consumption of Sublime Text is lesser …
    Incentivized
    Chose Sublime Text
    Compared to any other text editor I've used, Sublime Text has the best user interface. On Macs, Windows, and Linux, Sublime Text makes editing easier. When I couldn't use Notepad++ on a Windows machine, I used Sublime Text instead. My colleagues started using Sublime Text, so I …
    Incentivized
    Chose Sublime Text
    We've used both Notepad++ and Atom; both are great but nothing really beats the Sublime Text UI; super intuitive and friendly and does everything you need without overwhelming you with stuff you don't. Other options are free, but for our organization, it was well worth the …
    Incentivized
    Chose Sublime Text
    Sublime Text has a bit more flexibility and doesn't take up as much space or memory as some of the larger IDEs. Notepad++ is customizable too, but Sublime Text is better suited for code editing in my experience.
    Incentivized
    Chose Sublime Text
    While Microsoft Visual Studio Code has a lot more to offer, it can sometimes be a little too much and get too complicated. I like to keep things simple in text editors which makes Sublime Text my preferred editor. There are a lot of packages that can be installed for Sublime …
    Incentivized
    Chose Sublime Text
    The main reason I moved from using Notepad++ to use Sublime Text was that I moved from Windows OS to Mac OS....
    Notepad++ is not supported on Windows based systems, so I had no choice.
    But my guess is that over the years, I would have probably moved to Sublime Text anyway, since …
    Incentivized
    Chose Sublime Text
    Sublime Text has a better UI compared to any other text editors I have used. Easier to edit text on Sublime Text, even on Mac, Windows and Linux operating systems.
    Incentivized
    Chose Sublime Text
    On certain levels all have certain pros and cons but Sublime has community support and a huge future ahead due to its features, making it lead all the others.
    Incentivized
    Chose Sublime Text
    Sublime Text is powerful, stable, versatile, and lightweight. It's also very affordable, with straightforward licensing terms. Many of the other options that we explored met some of these qualifications, but only Sublime Text checks all of those boxes. For example, NetBeans and …
    Incentivized
    Chose Sublime Text
    I think Sublime Text is more elegant and simple to use.
    Incentivized
    Chose Sublime Text
    Sublime Text rarely has an bugs or updates compared to Notepad++, meaning it is always ready to go. Sublime Text has a smarter file recognition system that helps to correctly target directories for new files and choose the correct color highlighting scheme. Compared to …
    Incentivized
    Chose Sublime Text
    Sublime Text has the cleanest and best UI features such as code snippet window etc.. It has pre-defined intuitive keyboard shortcuts which are easy to understand and use. It also offers support for multiple languages.
    Incentivized
    Key User Insights
    Would buy again
    100%
    Would buy again
    41 Answers
    84%
    Would buy again
    21 Answers
    90%
    Would buy again
    26 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    41 Answers
    96%
    Delivers good value for the price
    24 Answers
    100%
    Delivers good value for the price
    26 Answers
    Happy with the feature set
    100%
    Happy with the feature set
    41 Answers
    88%
    Happy with the feature set
    22 Answers
    100%
    Happy with the feature set
    29 Answers
    Lived up to sales and marketing promises
    96%
    Lived up to sales and marketing promises
    26 Answers
    100%
    Lived up to sales and marketing promises
    10 Answers
    100%
    Lived up to sales and marketing promises
    17 Answers
    Implementation went as expected
    100%
    Implementation went as expected
    30 Answers
    95%
    Implementation went as expected
    19 Answers
    96%
    Implementation went as expected
    23 Answers
    Features
    Notepad++SSISSublime Text
    Data Source Connection
    Comparison of Data Source Connection features of Notepad++ and SQL Server Integration Services (SSIS) and Sublime Text
    Feature
    Notepad++
    -
    Ratings
    SQL Server Integration Services (SSIS)
    7.0
    56 Ratings
    18% below category average
    Sublime Text
    -
    Ratings
    Connect to traditional data sources00 Ratings9.056 Ratings00 Ratings
    Connecto to Big Data and NoSQL00 Ratings5.043 Ratings00 Ratings
    Data Transformations
    Comparison of Data Transformations features of Notepad++ and SQL Server Integration Services (SSIS) and Sublime Text
    Feature
    Notepad++
    -
    Ratings
    SQL Server Integration Services (SSIS)
    6.8
    56 Ratings
    18% below category average
    Sublime Text
    -
    Ratings
    Simple transformations00 Ratings8.956 Ratings00 Ratings
    Complex transformations00 Ratings4.755 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of Notepad++ and SQL Server Integration Services (SSIS) and Sublime Text
    Feature
    Notepad++
    -
    Ratings
    SQL Server Integration Services (SSIS)
    7.5
    54 Ratings
    6% below category average
    Sublime Text
    -
    Ratings
    Data model creation00 Ratings9.028 Ratings00 Ratings
    Metadata management00 Ratings6.035 Ratings00 Ratings
    Business rules and workflow00 Ratings7.145 Ratings00 Ratings
    Collaboration00 Ratings9.140 Ratings00 Ratings
    Testing and debugging00 Ratings6.451 Ratings00 Ratings
    Data Governance
    Comparison of Data Governance features of Notepad++ and SQL Server Integration Services (SSIS) and Sublime Text
    Feature
    Notepad++
    -
    Ratings
    SQL Server Integration Services (SSIS)
    5.4
    43 Ratings
    40% below category average
    Sublime Text
    -
    Ratings
    Integration with data quality tools00 Ratings6.238 Ratings00 Ratings
    Integration with MDM tools00 Ratings4.638 Ratings00 Ratings
    Best Alternatives
    Notepad++SSISSublime Text
    Small Businesses
    BBEdit
    Score10 out of 10
    Skyvia
    Score10 out of 10
    BBEdit
    Score10 out of 10
    Medium-sized Companies
    Vim
    Score9.8 out of 10
    IBM InfoSphere Information Server
    Score10 out of 10
    Vim
    Score9.8 out of 10
    Enterprises
    Vim
    Score9.8 out of 10
    SolarWinds Task Factory
    Score8.3 out of 10
    Vim
    Score9.8 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    Notepad++SSISSublime Text
    Likelihood to Recommend
    8.5
    (62 ratings)
    8.0
    (56 ratings)
    9.1
    (56 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    9.0
    (4 ratings)
    10.0
    (1 ratings)
    Usability
    9.0
    (4 ratings)
    8.0
    (11 ratings)
    8.9
    (4 ratings)
    Availability
    -
    (0 ratings)
    -
    (0 ratings)
    9.0
    (1 ratings)
    Performance
    -
    (0 ratings)
    8.8
    (6 ratings)
    10.0
    (1 ratings)
    Support Rating
    8.1
    (15 ratings)
    8.0
    (8 ratings)
    9.3
    (11 ratings)
    Implementation Rating
    -
    (0 ratings)
    10.0
    (2 ratings)
    -
    (0 ratings)
    Configurability
    -
    (0 ratings)
    -
    (0 ratings)
    10.0
    (1 ratings)
    Ease of integration
    -
    (0 ratings)
    -
    (0 ratings)
    7.0
    (1 ratings)
    Product Scalability
    -
    (0 ratings)
    -
    (0 ratings)
    8.0
    (1 ratings)
    User Testimonials
    Notepad++SSISSublime Text
    Likelihood to Recommend
    Open Source
    well suited for 1) Coding and Development - Writing and editing code, Quick prototyping and testing of code snippets, Debugging and inspecting code using syntax highlighting and line numbering, 2) web development - Creating and editing HTML, CSS, JavaScript, and other web-related files .Managing and organizing web projects with multiple files and directories. Not suited for - 1) processing huge files 2) graphic designing 3) complex gui designs 3) Data Analysis and Manipulation - Editing and cleaning up text-based data files before importing them into analytical tools. Applying regular expressions to extract, transform, and manipulate data. 4) System Administration and IT - change system configuration file
    Incentivized
    Read full review
    Microsoft
    As I mentioned earlier SQL Server Integration Services is suitable if you want to manage data from different applications. It really helps in fetching the data and generating reports. Its automation make it very easy and time efficient. It works well with large database as well. But it doesn't work well with real time data, it will take some time to gather the real time data. I would not recommend using it in a real time/fast-paced environment.
    Incentivized
    Read full review
    Sublime HQ
    My CMS has a small window in which I can edit custom HTML/CSS. It can be expanded some, but not as much as I would like. It also displays all code as dark text on a white background. On a page where I am doing extensive custom coding, it is helpful to see it in a larger window and in a color-coded display so that I don't have to strain my eyes as hard. Especially when I'm trying to scan for specific elements and target issues and so that I don't have to scroll endlessly in a tiny window.
    Incentivized
    Read full review
    Pros
    Open Source
    • Notepad++ allows us to keep open files in tabs. Like in a web browser, these tabs let us access these files quickly and easily. Furthermore, even if we forget to save the files when closing the program or shutting down the PC, Notepad++ retains them in the open tabs when we reopen it.
    • Notepad++ supports many different file types. We usually save our files created in Notepad as normal text files, but sometimes as JSON, PHP, and HTML files.
    • Notepad++ is lightweight and requires little resources. Using it is snappy and responsive.
    • The developer of Notepad++ frequently updates the software with bug fixes, performance improvements and new features.
    Incentivized
    Read full review
    Microsoft
    • Standard ETL use cases for daily loads
    • Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
    • Creating outgoing data files and writing them to Vendor FTPs
    • Easy Active Directory integration for seamless connections to SQL Server
    • CI/CD by hosting the code on visualstudio.com
    Incentivized
    Read full review
    Sublime HQ
    • It is very light and boots up instantaneously.
    • It has tons of plugins that will help you to customize sublime entirely according to your needs and thereby is not bloated
    • Package control is really easy to work with and most plugins can be installed in 2 just clicks.
    • Free version has nearly all the features of the paid version.
    • Its User Interface is simple and makes it easy to located many features.
    • It gives you a ton of control over your ide setting through User-settings where you can customize almost everything.
    Incentivized
    Read full review
    Cons
    Open Source
    • UI looks a bit dated.
    • Sometimes the number of options are overwhelming and require a quick search to figure out where to locate a particular function.
    • Some way to do a diff between files would be great. Still need to resort to another paid app for that - unless it is a buried function I don't know about or there's a plugin for it.
    Incentivized
    Read full review
    Microsoft
    • Connection managers for online data sources can be tricky to configure.
    • Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
    • Mapping destination using OLE DB command is difficult as destination columns are unnamed.
    • Excel or flat file connections are limited by version and type.
    Incentivized
    Read full review
    Sublime HQ
    • Plugins are easier to use and less complicated but transferring your license to a new computer isn't as simple as it sounds.
    • Sublime has an automatic file comparison feature, but it's challenging to use and should be improved.
    • Adding the ability to mark or highlight the text with different colors would be an excellent application.
    Read full review
    Likelihood to Renew
    Open Source
    I use it every day for 13 years already and it never disappointed me
    Incentivized
    Read full review
    Microsoft
    Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure
    Incentivized
    Read full review
    Sublime HQ
    I love this application. It has helped to improve my work. Also, I became so used to the shortcuts that It's hard for me to change to another editor.
    Incentivized
    Read full review
    Usability
    Open Source
    There are lot of features to talk about. Especially the usability is good. Everyone can easily to use and user-friendly. Can also update easily. Can also write and execute the programming languages like C, C++ etc. Encoding is also the major feature that helps me a lot and converter as well.
    Read full review
    Microsoft
    SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.
    Incentivized
    Read full review
    Sublime HQ
    This is a programmers tool. As such a lot of the features and benefits are lost on a non-technical user. To get the most out of the tool you need to have a basic crash course in how it works and what it can do. The documentation and community are good, but it takes a bit of time to get up to speed.
    Incentivized
    Read full review
    Performance
    Open Source
    No answers on this topic
    Microsoft
    SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.
    Incentivized
    Read full review
    Sublime HQ
    It has many handy hacks and shortcuts which enhances its performace.
    Incentivized
    Read full review
    Support Rating
    Open Source
    I haven't needed to utilize any support related to Notepad++. I guess this is a good thing because I found it to be quite intuitive. There are almost infinite features you can tweak and plugins you can download but I haven't had to do that because Notepad++ is really good right out of the box.
    Incentivized
    Read full review
    Microsoft
    The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.
    Incentivized
    Read full review
    Sublime HQ
    Never had to use their customer support before. There is ample documentation online so it's straightforward to find a solution to any problem you might encounter. For example, I needed to convert a string of HTML code to a properly formatted HTML file to "modify." Easy to do when there are so many users of the product who have needed to do that same thing before.
    Incentivized
    Read full review
    Implementation Rating
    Open Source
    No answers on this topic
    Microsoft
    The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools
    Incentivized
    Read full review
    Sublime HQ
    No answers on this topic
    Alternatives Considered
    Open Source
    Notepad for Windows, Microsoft Word...LibreOffice Writer....I have used all of these for code writing and editing. Once again I like the universal feel of Notepad++. Basic Notepad, is just that, basic...and kind of clunky for what it is. This is a cool that I have installed on all my computers and also keep it on a thumb drive if I need it elsewhere.
    Incentivized
    Read full review
    Microsoft
    I think SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer
    Incentivized
    Read full review
    Sublime HQ
    We've used both Notepad++ and Atom; both are great but nothing really beats the Sublime Text UI; super intuitive and friendly and does everything you need without overwhelming you with stuff you don't. Other options are free, but for our organization, it was well worth the small license cost for the persistent use of a great product.
    Incentivized
    Read full review
    Return on Investment
    Open Source
    • Productivity has increased for developers.
    • It's free so instead of buying a piece of software, you can use this to replace many of them that may only specialize in one thing.
    • It gives our developers confidence knowing they have such a reliable, free tool at their disposal.
    Incentivized
    Read full review
    Microsoft
    • Without this, we would have to manually update a spreadsheet of our SQL Server inventory
    • We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
    • We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.
    Incentivized
    Read full review
    Sublime HQ
    • Sublime Text has helped me to focus on specific tasks, cutting out the clutter that many other IDEs have. As such, it has helped me be a more productive employee because I don't get dazed by hundreds of buttons. I can focus on just the code.
    • Sublime Text is so affordable that it's a no-brainer to have an extra tool in your toolset.
    • The Search features of Sublime Text are so useful that it has saved me a great amount of time compared to using Find & Replace menus in Xcode, Android Studio, or Eclipse.
    Incentivized
    Read full review
    ScreenShots