With >2,000 points, you should know how to submit formatted SQL by now.

CREATE VIEW dbo.vwTEST --
AS

WITH t
AS (
   SELECT er.Ece_ID
     ...

• This reply was modified 5 years, 3 months ago by Phil Parkin.

Hi Phil,

That's exactly what I was looking for!

I did find the Profiling Node in SSIS which gave me similar stats to what you extracted in Python.

I also like the...

As far as I know, there is no fixed way of doing this.

I used to have a series of files which were loaded every month and we had to be...

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 5 years, 3 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...