Andy Leonard

  • Interests: SQL Server, Integration Services, Managing Technical Teams, Faith, Family, Farming.

Stairway to Integration Services

Flexible Source Locations - Level 16 of the Stairway to Integration Services

Integration Services can be used to load data from a number of source files stored in different folders. This next level in the Stairway Series for Integration Services shows exactly how you can use parameters, variables and the ForEach Loop Container to do this.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

7,289 reads

Stairway to Integration Services

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services

Part four of this stairway series examines the process of updating the data in an existing table in a load. MVP Andy Leonard talks about the way in which packages can handle changes in a repeatable fashion.

You rated this post out of 5. Change rating

2019-03-26 (first published: )

56,894 reads

Blogs

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

South Kerala Tour Packages

By indiaboundtour

South Kerala tour packages offer an immersive experience into the heart of Kerala's natural...

Black Corgi Chihuahua Mix – Unique Look and Personality

By dogshabit

Ever seen a corgi chihuahua mix black, or "Chigi"? This rare color variation makes...

How to change font size in Query window

By MurraySobol

I am running SQL Server 20.2. When I copy a query into the query...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers