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.

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

cannot convert between unicode and non-unicode string data types, SSIS

SSIS error:

solution
http://www.mssqltips.com/tip.asp?tip=1393

#database side

1) change the column width in database table for the error coulumn.

#SSIS package side

1) Right click 'Flatfile editor' and select 'Advanced' editor
2) Go to 'Input & Output Properties'
3) Expand 'Flat File Source Output
4) Expand the 'Output columns'
5) Select Error column and change the length.

-- Yup, refresh you're OLEDB connection with updated table information.

ready to go...