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

I have managed to resolve this issue (it was keeping me up at night!)

I can hardly believe the solution and do not understand why it works, but it does. It...

What is the error message you receive?

Like a COALESCE with 10 arguments, for example. Why...

CLR functions for performing Regular Expression searches aren't SQL either, but they're useful. Where do you draw the line?

IIF is part of T-SQL and is more succinct than CASE, and...