Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

When extracting data from a flat file, it is handy to have the name of the file from which the...

Extract the File Name in SSIS Data Flows using the FileNameColumnName Property

When extracting data from a flat file, it is handy to have the name of the file from which the data was retrieved. Whether you capture this information for...

Test connection failed because of an error in initializing provider. Oracle client and networking components were not found

You may experience the following error. When a...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

Test connection failed because of an error in initializing provider. Oracle client and networking components were not found

AdvertisementsYou may experience the following error. When a developer installed oracle client and tested the visual studio BIDS packages ask...

Using the SSIS Multiple Flat Files Connection Manager

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data...

Using the SSIS Multiple Flat Files Connection Manager

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data spread across multiple files. For example, if you are...

ASF 017: Alex Whittles interview

Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the...

Azure Backup Storage Options

As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012,...

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server Land
A week is a long time in SQL Server land. This week...

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...