Data Types of Columns

SELECT

case when data_type in ('char', 'varchar', 'nvarchar')

then DATA_TYPE + '(' + cast(CHARACTER_MAXIMUM_LENGTH as varchar(5))+ ')'

else DATA_TYPE end as ColumnType,

*

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'wholesales'

View SSIS PackageSource Contents

SELECT [name]
      ,[id]
      ,[description]
      ,[createdate]
      ,CAST(CAST([packagedata] as varbinary(max)) as xml) AS PackageSource
      ,[packagetype]
      ,[vermajor]
      ,[verminor]
      ,[verbuild]
      ,[vercomments]
      ,[verid]
      ,[isencrypted]    
  FROM [msdb].[dbo].[sysssispackages]