Home » ssis http connection

How to create BIML custom task or component

Posted on September 21, 2017May 22, 2018 by ZappySys

Introduction BIML or Business Intelligence Markup Language is a nice technology that lets you generate SSIS packages using a bit of scripting and parameters. Check for more info if you are new to it: https://en.wikipedia.org/wiki/Business_Intelligence_Markup_Language http://bimlscript.com/ In this article we will cover the points how to create BIML custom task or component. For this purpose […]

Calling REST API in SSIS with Basic Authentication / Userid-Password (BASE64 Authorization header)

Posted on August 27, 2015September 8, 2023 by ZappySys

Introduction In this blog post you will explain how to pass basic credentials (i.e. UserID/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume / call REST API in SSIS check this article. HTTP Authorization Header […]