The problem is you are trying to OUTPUT a column from table @MyTable that does not exist on @MyTable(MyData.C).

Are you sure there is only one index on the table?
Does the query you use to insert data reference the insert table in a query (or any other table)?

Everything in the inline table needs to have a distinct column names. So instead of just SELECT * you need to list the columns you want.
If you want two...

I've done something similar with SSIS (a few years ago).
I needed to get a temple spreadsheet with a table in it, to do this I created a new...

Unless you use dynamic SQL you will have to write something like this:
SELECT CASE DATEPART(day,GETDATE())
    WHEN 1 THEN t.Col1
    WHEN 2 THEN t.Col2
    ...

INSERT INTO [dbo.Distinct_Login]
select GETDATE(), DB_NAME(dbid)AS DatabaseName, MAX(LOGIN_TIME), HOSTNAME,CMD,NT_USERNAME,LOGINAME
from MASTER.DBO.Sysprocesses where spid > 25
group by DB_NAME(dbid),HOSTNAME,CMD,NT_USERNAME,LOGINAME

Can you use datetime2 in SSIS? This will store 01/01/1000 as a date:
declare @Date as datetime2(3)
set @Date ='1000-01-01'
select @Date

It's a really impressive script. I think it's worth changing the table definition in of #ByCell in script Soduku_PJR to remove the name of the primary key and then republish the...

What type of column is dbo.TargetData(UniqueID)?