Nat Sundar

Nat Sundar is working as an independent SQL BI consultant in the UK with a Bachelor’s Degree in Engineering. He has considerable years of experience with the UK Financial Services Industry (mainly in Insurance and Investment Banking). He is passionate about SQL Server, SSIS, SSAS, SSRS and MDX. He has presented at SQLBits, SQLPass and the SQL London User Group. He has special interest towards Continuous Integration, Continuous Delivery and Deployment automation for the SQL BI (SSIS, SSAS and SSRS) stack. He can be contacted at sqlnat@gmail.com, via LinkedIN and on Twitter at @SQLNat.

Articles: 38

Integration Services Control Flow Transformations

Search File Extensions with SSIS Foreach File Enumerator

In this tip I cover a workaround to search for multiple file extensions when using the SQL Server Integration Services (SSIS) Foreach File Enumerator.

Nat Sundar
February 14, 2017

Integration Services Development

Developing a File Watcher Task for SSIS

SSIS does not have a default task to check a poll a folder to see if a specific file exists. There are third party controls that can assist us with this task, but not all organizations allow the use of third party controls in SSIS.

Nat Sundar
February 2, 2017

Application Development

Getting Started with Scrum for SQL Server Development Projects

We are embarking on a new SQL Server project initiative with Agile/Scrum methodologies. To get started, what is a Daily Scrum and what do we discuss during this meeting?

Nat Sundar
January 13, 2017

Database Administration

SSIS Package to Automate Code Deployment of Database Changes

All DBAs and Developers need a way to deploy there SQL code. There are several ways that this can be done. In this tip we look at an approach that uses SSIS as the deployment tool.

Nat Sundar
January 2, 2017

Integration Services Development

SSIS Variable and Expression Example – Part 1

What is a SQL Server Integration Services (SSIS) expression? How can we use SSIS expressions to modify the package properties during run time? What types of objects can invoke an expression?

Nat Sundar
December 28, 2016

Integration Services Development

Data Sampling in SSIS

When developing SSIS packages, sometimes it is easier to work with a sample dataset instead of the entire dataset. In this tip we look at a couple of different ways to do data sampling transformations in SSIS.