bump for visibility.

and speed differences may be to do with settings on ssms vs vb.net

it really shows a lack of understanding of how SSIS Catalog deployment works, even within VS (which does invoke a command line tool to deploy).

everything can be deployed from CI/CD...

what happens if you move that SP to another container, being executed after the other ones?

and most times its some settings on your sp's or locking between SP's - and...

the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.

while there are 2 ways...

doing a select * in SSMS will also be impacted by network speed between workstation and server, workstation processor (and available cpu %), memory, disk speed, and SSMS settings.

if you...

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 saw the...

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...