INSERT INTO [dbo.Distinct_Login] (
  [Today], [DatabaseName], [lOGIN_TIME], [HOSTNAME],
  [CMD], [NT_USERNAME], [LOGINAME]
  )
select
    GETDATE() AS today, DB_NAME(dbid) AS DatabaseName, LOGIN_TIME, HOSTNAME,

Or have SSIS convert that value to a different date.  Typically 1900-01-01 is used (date 0 in SQL) for that, unless you have actual data that goes back that far,...

That's an odd requirement.  The same login could have several different processes active on SQL at the same time.  How do you want to determine which single one to list? ...

Something like this instead:

delete from C
from ods_tmus4.dbo.lgtc_shipmentsclaims_cpy C
where exists (
select *
from [Admin].[dbo].[Remove Duplicates_Final] D
Where D.[Tracking_Number] =...

There is no connection between the table you're deleting from and the EXISTS clause.  If the EXISTS is ever true for the tables it references, even for just one row,...

That's one of the reasons SQL allows NULL "values" in columns (NULL is technically not a value, it's the absence of a value; for day-to-day purposes, you can think of...

It's easy enough to get a list of the missing values.  But getting a concatenated list is somewhat more difficult.

;WITH cte_packages AS (
   ...

The "WITH" from a CTE can cause errors if not preceded by a ; if an actual statement preceded the WITH.  Therefore it's safer to prepend a ; so that...

In the WHERE clause, don't.

WHERE (@chan_id IS NULL OR tablea.chan_id = CAST(@chan_id AS...