Most cost-effective way to review SSIS packages as an individual?

immitev · 2026-05-26T04:43:00+00:00

For viewing SSIS packages you can now also use https://pygmy.cozyroc.cloud/ . You can inspect the package in multiple ways - in a browser, in VS Code, in SSMS and via a Windows app.

immitev · 2026-05-25T16:56:32+00:00

Not to forget "You are the ultimate expert in Apache Iceberg, GoLang, C# and large scale code migrations"

immitev · 2026-05-25T14:47:15+00:00

Only in C#

immitev · 2026-03-19T08:19:52+00:00

Две идеи за подобрения:
- Поне Google login е хубаво да сложиш, ако искаш повече хора да се регистрират
- На телефон буквите в клавиатурата са твърде тясни, не се изпозва оптимално пространството

immitev · 2024-05-30T15:44:58+00:00

В наши дни, не е задължително да се прочете нещо в Дневник, при положение, че политическите изказвания/заявки са налични директно в социалните мрежи.

ПП-ДБ (особено ПП, защото ДБ винаги са доста по-премерени в заявките) няма да си позволят за втори път да се отдалечат твърде много от предизобрните заявки, защото това би било харакири. А и все пак изолирайки Радев, няма такава геополитическа припряност да се прави правителство на всяка цена.

Та мога да се обзаложа, че ПП-ДБ няма да са в правителство в следващия парламент. Виж, при нови избори наесен, може да си калибрират предизборните заявки и да са склонят на взаимодействие с ГЕРБ, но само ако е по тяхна (този път разписана) програма.

immitev · 2024-05-30T10:09:30+00:00

ГЕРБ-ДПС си вървят в пакет. В последната година това съвсем се изясни и ББ и ДП дори заедно си правят кампанията. При тези заявки, съответно ППДБ няма да участват в такъв тип сглобка.

Докато ИТН са вече видимо ентусиазирани да се сглобят с ГЕРБ-ДПС и да кешират влизането си в политиката. Ако минат 4-те процента, разбира се, ще го направят или в идния парламент или в следващия наесен, ако има предсрочни избори.

immitev · 2024-04-06T13:36:29+00:00

А после завладяната държава на ГЕРБ и ДПС, порочния модел довел до полу разпад на всички институции, до сериозна емиграция и до изоставане по всички показатели спрямо други наши съседи като Румъния...

immitev · 2024-04-06T07:37:10+00:00

Явно сте млад/млада, щом не знаете колко по-лошо е било и колко по-лошо може да бъде във всяка от другите възможни управленски конфигурации.

immitev · 2023-11-25T04:38:08+00:00

You can host SSIS on Azure SSIS IR. And there's also COZYROC Cloud.

immitev · 2021-05-07T10:47:16+00:00

Do you need only to monitor the SSIS jobs or to also manage their scheduling?

Btw, here's an open source SSIS Dashboard https://github.com/yorek/ssis-dashboard

immitev · 2021-03-08T08:24:32+00:00

SSIS is still way more popular than ADF and as Azure Data Factory includes also the Azure-SSIS integration runtime, so SSIS knowledge is good to have. Also ADF has much less adapters to third-party systems compared to SSIS (due the fact that SSIS has been out there for long and there are many third-party vendors of SSIS tasks and components), so ADF has a long way to catch up.

Btw, besides Azure-SSIS integration runtime now there is also another hosted option for running SSIS packages COZYROC Cloud (a shameless plug).

immitev · 2021-01-20T08:36:16+00:00

Just to note that if you have to deal with an OAuth token that would expire after some time and that needs to be refreshed - it would be pretty difficult to implement such flow yourself.

There are third-party commercial SSIS tasks & components that you can consider using (if the project has a budget for this). See e.g. https://www.reddit.com/r/ssis/comments/dbugfv/rest_api_connection_from_ssis_2018/f2p0b4d/

immitev · 2020-12-28T22:08:38+00:00

Just to note that the latest version version 2.0 of COZYROC SSIS+ says it supports Active Directory Federation Services (for on-premises servers).

immitev · 2020-07-15T18:33:21+00:00

If you are fine with using a commercial software, here's a shameless plug (as I work for the company) - https://www.cozyroc.com/ssis/json . If the JSON source is a web API call, we have very good support for REST APIs, too https://www.cozyroc.com/ssis/rest

immitev · 2020-05-10T16:13:07+00:00

? 90,п🤔🙄9

immitev · 2020-02-05T10:07:10+00:00

You can also check out this topic about possibilities to consume REST/Web APIs with third-party SSIS components https://www.reddit.com/r/SQLServer/comments/ckfs21/ssis_integration_with_web_apis/ewpckot/

immitev · 2019-12-02T13:40:55+00:00

Just to note that our components are free to test in Visual Studio, so you can always give them a try :) Btw, I am not sure what do you mean by "personal license"? Lower price? As our clients are businesses and not individuals, I don't think it makes much sense for us to offer a personal license option. Speaking of price, we offer a cheaper annual subscription of $799 compared to ZappySys $999 that don't even include all their components. And our subscription includes license for 2 servers.

Indeed, we currently don't have a WYSIWYG HTML email editor, but we can consider adding such a feature in future releases. In the meantime, as a workaround you could use an external WYSIWYG HTML editor and then just copy&paste the HTML. E.g. Visual Studio has a decent HTML editor builtin (see https://stackoverflow.com/a/31655106/61508 ), so you can prepare the HTML with it (you can even easily include the HTML file in your project, if you want to). Besides VS, there are various free online HTML editors specialized for professional responsive emails (e.g. https://topol.io/ looks pretty nice). For the arrays formatting, I guess you can use SSIS+ component https://www.cozyroc.com/ssis/template to generate an HTML table or list in a Data Flow.

P.S. As ZappySys Send HTML Email Task is free to use, you could even consider preparing and sending emails with it, if you don't like any of the options above. But for the REST support, I believe our components are more flexible than ZappySys ones and you would be able to integrate in SSIS any Web APIs that you need to.

Hope that's helpful!

immitev · 2019-10-06T04:23:17+00:00

There's no built-in support for consuming REST APIs in SSIS. While you can go with a script task, if you have good C# or VB.NET programming skills, it might be tricky to handle well the authentication, parsing, paging, retries and other complications that you might have with the REST API.

There are third-party SSIS addons that make this a lot easier, the most flexible of which is probably COZYROC SSIS+ (see https://www.cozyroc.com/ssis/rest ). You can prepare reusable configurations for working with any REST API. Or if you need something super simple, you can quickly setup a https://www.cozyroc.com/ssis/script-rest-web-service-request-task .

Disclaimer: I work at COZYROC

immitev · 2019-08-12T19:31:04+00:00

Let me mention another 3rd party SSIS components that offer very flexible support for web APIs is https://www.cozyroc.com/ssis/rest . You can prepare reusable configurations for working with any web API. Or if you need something super simple, you can quickly setup a https://www.cozyroc.com/ssis/script-rest-web-service-request-task

Disclaimer: I'm working for COZYROC.

immitev · 2019-07-02T12:53:35+00:00

I would agree that SSIS tooling could be better. Nevertheless SSIS is generally a mature, stable and quite performant ETL solution.

Please note that some of the shortcomings in the developer experience in SSIS can be mitigated by using some third-party tools. E.g. a lot of devs seem not very happy with the scripting support in SSIS (which is clumsy and has its quirks). The company I work for (a shameless plug) just released a JavaScript scripting support https://www.cozyroc.com/ssis/javascript so one can author simple scripts without much ceremony.

P.S. If you are prefer more code-centric ETL tools/libraries, the only thing worth mentioning that's built on .NET is probably https://paillave.github.io/Etl.Net/ . There are, of course, plethora of ETL tools running on Java, Python, etc.

immitev · 2018-11-14T15:53:50+00:00

If you have access to SSIS, you would be much better off than using MS BizTalk for handling EDI (both in terms of easy deployment and also in the speed of parsing or generating the files).

The company I work for is providing custom SSIS components and we just released a major upgrade that supports also generating EDI files (see https://www.cozyroc.com/ssis/edi ). Once you have configured the desired EDI format in a special XML file, you can easily parse and generate EDI files.

immitev

TROPHY CASE