I don't know the answer, but may have an alternative solution.

Use a Conditional Split to redirect rows which you do not want, by sending them to an unused output.

Your Script...

Thank you.

But i would like to use the function "len".

if the len(id) = 14 then it should be in ID1 otherwise it should be in ID2.

Can we achieve it...

SELECT e.Firstname
      ,e.Lastname
      ,ID1 = MAX(e.ID)
      ,ID2 = MIN(e.ID)
FROM dbo.Emptable e
GROUP BY...

• This reply was modified 4 years, 9 months ago by Phil Parkin.

I would like to display the result in single row  like below based on len(id) column.

What does 'based on' mean here?

Where are your sample DDL and INSERT statements?

SOX requirement, by any chance?

What is your data source?

Are they logged in using Windows auth? SSIS does not like SQL Server auth very much.

Are you talking about INSERTS only, or also UPDATES and (maybe) DELETES?

SSIS can probably do it (depending on your answer to the above and the existence of columns such as...

Can you provide some code that demonstrates the problem, which we can run for ourselves?

Maybe you could add

UNION ALL
SELECT 0
      ,NULL;

to the end of your query. Then a (0,NULL) row will always appear in your results.

I'd add a 'make sure you take a copy of the DTSX file before editing' warning to this. Do it wrong and it will no longer open in SSDT. Of...

If you told us the text of the error message it might help.

I had assumed that the DENSE_RANK() was there for a reason! If your...

Something like this?

WITH ranked
AS (SELECT te.department
          ,te.salary
          ,rnk =...

OK, that looks like two instances on the same server. One called CONFLUENCE and one called EPO.

EPO looks active, CONFLUENCE not.

I recommend that you don't shut down the server until...

Do you know how SQL Server is structured?

There is a thing called an 'instance' and the services associated with it (SQL Server, SQL Agent and others) run the instance.

Databases are...