Copy environment variables between SSIS catalogues on different servers

Problem Usually when developing SSIS packages, you want the project to run on different servers, e.g. development, test and production server. If you have many environment variables creating all of them is tedious and unnecessary work. I’ll show you how you can copy environment variables between SSIS catalogues that are located on different servers. Solution … Continue reading Copy environment variables between SSIS catalogues on different servers

Easy and efficient way to log overwriting of a directory in SQL Server Integration Services (SSIS)

Recently I had the problem that I had a File System Task that moved a file but whenever the file was already there the package failed. So I set OverwriteDestination to TRUE. But now I lost complete control over which files were just moved and which did overwrite some already existing directory. My desired result … Continue reading Easy and efficient way to log overwriting of a directory in SQL Server Integration Services (SSIS)

[SSIS tips] Error when file path variable is not set at design time

A few weeks ago I had to create a foreach container in an ETL package to loop over subdirectories of a folder. There are many tutorials out there for this purpose: microsoft-ssis.blogspot.co.at blogs.msdn.com/b/changliw/ In each iteration of the loop some files of each subdirectory where read. And since the path of these files were created … Continue reading [SSIS tips] Error when file path variable is not set at design time