Showing posts with the label 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 Storag…

Active Directory as Source

Case I want to use the users from my Active Directory in my Data Warehouse for an Employee Dimensio…

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 des…

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 sup…

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 producti…

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…

Eventlog as a source

Case I want to use the Windows Eventlog as a source in SSIS. Solution You can either read the saved…

Script Component as source 2

Case This is an follow up on another strangely formatted file article : My CSV file has splitted ro…

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&…

Load More That is All