Phil Parkin wrote:

Generalising your argument:

It's OK to discriminate, as long as the one discriminating is in the minority.

Are you comfortable with this?

Congratulations Phil. After years of silent lurking, you managed...

Fair enough.

Does the table msdb.dbo.sysdac_history_internal contain anything useful?

Completely missing the point, Phil.

It's not discrimination. You are not being forbidden from attending these conferences. You are not incapable of getting jobs or networking because of your gender...

The problem is that women and PoCs don't have an equal seat at the table. Men is Tech and White is Tech is the systematic default. Everything supports CIS...

I have not tried this, nor have I used that functionality, so this may not be of help, but have you considered putting a simple trigger on msdb.dbo.sysdac_instances_internal to push...

+1 for using a splitter to do this.

I would want the first two rows returned...

If you would like a coded solution, please provide your sample data in the form of CREATE TABLE/INSERT statements.

Please also confirm the logic for which row should be returned in...

Are you saying that the package fails on its first run, but you don't want that to happen?

Or are you asking for help diagnosing the connection issue?

Please clarify.

I misunderstood the requirement – you want to split the rows contained in the table across a number of files. My comment (5) therefore makes no sense whatsoever!

The method described...

I need a simply file compare of 2 files with no headers, but the 5th column in both files contains a value that has dates, and the 1st,2nd,3rd columns...

I have a few quick comments.

1. Using a table variable for such large volumes of data is usually not a great idea. A temp table will almost certainly perform better.

...

Have you tried using VS Code? If you grouped your projects by folder and used VS Code's open folder function, you might get something usable.

Before I HF'd Prod today, there had been no SSIS deployments since June 9th.

(If you'll pardon the expression) I played around with the package quite a bit, as I was...

Hi Tim...