Tuesday, February 5, 2019

SSIS - How to read file header columns in Script Task

In this tutorial, we will learn How to read header columns of a file in script task in your SSIS package. 

For validation of incoming record from flat files, we need to read the first row and validate with our destination table rows if it is matched then only we need to load the values otherwise we need to send the error email to concern person.

It is very use full for validating before file load otherwise if we load with different records our package will get fails and again we need to debug the package and find the issue and it will go long process.

Using components - 1. Variables 2. Script Task

This tutorial is using very basic steps to read your header columns in script task. To learn in details, please watch the below video -

⭐To learn more, please follow us - http://www.sql-datatools.com ⭐To Learn more, please visit our YouTube channel at - http://www.youtube.com/c/Sql-datatools ⭐To Learn more, please visit our Instagram account at - https://www.instagram.com/asp.mukesh/ ⭐To Learn more, please visit our twitter account at - https://twitter.com/macxima ⭐To Learn more, please visit our Medium account at - https://medium.com/@macxima

1 comment:

  1. They can make reference to this endorsement in their resume to weightage to it.ExcelR Data Science Courses