A formatted version of the OP's query:

SELECT service_form_name = selected_sfs.sfName
      ,age = c.agingDays
      ,documents.document_id
   ...

Calling Excel from SSIS is possible, though it requires Excel to be installed on the server next to where SSIS is running and I would not encourage that.

I cannot think...

Dear Friends,

Would be grateful if anybody can advise why one of my servers, doesnt allow a connection anymore from SSMS on my terminal. The IP address is the unchanged....

I wanted to test this, but after running the two 2022 installation files (from here), the PQ connector did not appear for me in VS2022. Can't see anything which...

The image you have posted is of an OLEDB Destination.

What does your source look like? Does it have output columns?

If you're going to create a temp table, at least make it temporary!

DROP TABLE IF EXISTS #sat_temp;

CREATE TABLE #sat_temp
(
    Domain NVARCHAR(255)
);

INSERT #sat_temp
(
  ...

EXISTS will do it. But as you have not provided consumable data, I can't code it for you.

WITH bunch
AS (SELECT caseid
          ,anotherid
          ,locked
   ...

First I want to thank anyone who takes a moment to help with this.  I really appreciate all the help I've gotten here over the years and I wish...

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

I've not heard of anything like that, not that I've looked.

But if you are able to pull together some sample data and desired results, someone here might have a go...

You can use CASE in ORDER BY and you can get variable sorting to work. You can also get round the varchar/numeric issue by using an expression in the ORDER...

No, this is not...

If you can recreate the issue in a test environment, can you try removing the index, performing the problematic insert & then looking at the results?

Or could the source data...

Rather than setting the column types, I suggest you add a data conversion component after the source to convert from source to target datatypes. It is these converted columns which...

Thank you for elucidating. It's a really interesting problem.