No Object Exist with Lineage ID of XXXX in SSIS

Please click below link
1) when you migrate your SSIS package to SQL higher version
2) place square brackets around column name in SUBSTRING function

see below link

click here



done.

Simple C# code to get Quarters

 public static DateTime GetQuarterStartDate()  
     {  
       DateTime date = DateTime.Today;  
       int quarterNumber = ((date.Month - 1) / 3) + 1;  
       return new DateTime(date.Year, (quarterNumber - 1) * 3 + 1, 1);  
     }  

empty toolbox in ssis, there are no usable controls in this group.

1) If you open Integration Service Project solution and you can see below

2) right click on your package and select SSIS toolbox

 

thanks