SELECT DISTINCT tp.client_id AS Member_ID
     , tp.PaidDate AS Paid_Date
     , tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and...

This does not bring back any records unfortunately:

SELECT DISTINCT tp.client_id AS Member_ID
, tp.PaidDate AS Paid_Date
, tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and tp.PaidDate BETWEEN @startDate AND...

SELECT DISTINCT tp.client_id AS Member_ID
     , tp.PaidDate AS Paid_Date
     , tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and tp.PaidDate BETWEEN...

That's exactily the reason why we scan and alert for such usage (use of own database name).

Do this for as well sprocs, views, functions, ...)

"Sloppy development" like "start from...

this looks simpler.  may try it.  https://stackoverflow.com/questions/13627337/read-excel-cell-values-with-ssis-script-task   .   not sure if sheet has to be a table or not in order for the select statement to work.

just...

Consider VBA for extracting cell-level data, you can run the script directly from Excel. You could create a macro that triggers on a specific event, like opening the workbook...

look at https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-data-flow-script-component-types/creating-a-source-with-the-script-component?view=sql-server-ver16 - this can feed to any dataflow component that accepts input (union is one of them)

original question - NO - you can not have the output of powershell as a source on your dataflow - you could however do the same in C# component source.

Regarding...

not me (and many of the prior replies are trolls I believe)

Yes, despite some rather "hacky" solutions, you can't have the x86 and x64 Redistributables installed on the same system.  Ideally, you have the one that matches what's on the...

that wording from the ACE page is just that - words. there are no restrictions within the software as I use it on our servers.

but have a look at

when a user with sysadmin executes the package from the catalog SQL Server will use its own account instead to execute - this will likely bypass some of the security...

if you have the data available within c# then you are doing something wrong.

even if only c# was available, and you have to do that conversion within C# (which you...

based on all your threads about powerbi and ssis why don't you go read https://www.mssqltips.com/sqlservertip/6333/sql-server-integration-services-power-query-source/ - if it works for some it needs to work for you -...

you likely need to grant read/write permissions on the SQL Agent and SQL Instance accounts temp folder to the accounts executing the packages. ACE driver reads/writes files there while processing...