Posted in Data Migration, SSIS

SSIS – Flat File Package Logger – Part 2

In my previous post, I have explained how to create reusable SSIS Template in SSIS packages. If you haven’t read, I strongly recommend to go through SSIS – Flat File Package Logger – Part 1

Today’s post is all about

  • Package parts variables and its scope
  • How to use SSIS reusable templates in actual SSIS packages ?
  • How to pass values to the package parts ?

Package parts variables and its scope

Would you like to develop your package part more dynamic / configurable?

Go for using “variables” in the package parts. It will act like input and output parameter. Continue reading “SSIS – Flat File Package Logger – Part 2”

Posted in Data Migration, SSIS

SSIS – Flat File Package Logger – Part 1

Is it possible to develop something “re-usable in SSIS” ?

download

Yeeaaaahh !! We can develop re-usable control flow parts. Its available as part of SQL Server 2016.  

I believe MSBI professionals aware of this new feature.

For more details on this: https://msdn.microsoft.com/en-in/library/mt620034.aspx

Requirement:

  1. Generic requirement in package development is that we need to log the package details like package name, start time, end time, row count details, error details. So it helps a lot for the deployment/developer team to review the package status and investigate the issues if required.
  2. Each and every package will have the logger. Ideally we will develop some control flow or data flow to achieve it and copying the same to all the packages.

Continue reading “SSIS – Flat File Package Logger – Part 1”