Search Suggest

SOURCE
SOURCE

Azure Blob Source ≠ Flat File Source

Case I'm running my SSIS packages in Azure and my source is a flat file in an Azure Blob Storage container. Therefor I use the  Azure Blob Source…

Active Directory as Source

Case I want to use the users from my Active Directory in my Data Warehouse for an Employee Dimension. How can I accomplish that in SSIS? Solution Wit…

SSIS Appetizer: XML source is already sorted

Case I have a large XML file with Orders and Onderlines which I want to (merge) join into a new destination. To join the two outputs I need to order …

SQL Server 2016 CTP 2.3 OData V4 protocol

SSIS 2016 CTP 2.3 introduces an ODdata Source Component and an OData Connection Manager with V4 support . It now supports: OData V3 protocol for ATOM…

XSD location hardcoded in XML source

Case The path of the XSD file in the XML Source component is hardcoded, but the path on my production environment is different than my development en…

BUG: Could not decrypt file

Case I have an Excel (xls) file as a source and it has cell protection turned on to prevent editing the wrong cells. It's an official form from a…

Eventlog as a source

Case I want to use the Windows Eventlog as a source in SSIS. Solution You can either read the saved eventlog files (*.evt / *.evtx) with for example …

Script Component as source 2

Case This is an follow up on another strangely formatted file article : My CSV file has splitted rows. There is only one attribute on each row: id,1 …

Script Component as source 1

Case My CSV file has some rows where not all columns at the end of the row are filled: "test1";"abc";"xyz";"123&qu…