Hi Phil,

Yes, I opened the XML's as well and saw that they are not there but in the Connection Managers window they are...

"You can rename the connection manager without...

First of all, I find it odd/annoying that I can't exclude a Project level connect from a package Connection Managers... at least I can not do it. Why should they...

Create a variable and add an expression which evaluates to the exact query you want to execute. Use that variable as your source query.

If you modify the source query for the Oracle data to select where

StartDate <= LoginDate <= EndDate

, can you then do the lookup in the way that you wish?

Like this, perhaps?

DROP TABLE IF EXISTS #SomeData;

CREATE TABLE #SomeData
(
    SomeDate VARCHAR(64)
);

INSERT #SomeData
(
    SomeDate
)
VALUES
('Sun Sep 29 2024 09:28:55 GMT+0000 (Coordinated Universal Time)')
,('string...

Yes there is. You can assign the result of running a query in an ExecuteSQL task to an SSIS variable

This variable can then be used to build...

• This reply was modified 1 year ago by Phil Parkin.

While I don't know the answer to your question, my question is why are you writing your update like this? Why not this?

UPDATE TempSel
SET WertA = 'TEST'
WHERE...

What does 'termed out' mean?

Can you provide your sample data in consumable format, please?

Save this as a .VBS and then double-click … it still works on W11:

msgbox...

That is SQL Server 2019, which explains the error message.

If you need to guarantee that your results are presented in the order in which they appeared in the original string,...

• This reply was modified 1 year ago by Phil Parkin.

That was not an SSMS error, it was an error generated by the server when attempting to execute your query. You can see your SQL Server version by running this:

Check this article for the DelimitedSplit8k function:

https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%E2%80%9Ccsv-splitter%E2%80%9D-function

We have assumed that you are using SQL Server 2022, as that is the forum you have posted in. The third argument of...

One possibility

DECLARE @x VARCHAR(500) = 'Hello world.  #1234 has been replaced by #014521';

SELECT STUFF (value, 1, 1, '')
FROM STRING_SPLIT(@x, ' ')
WHERE LEFT(value, 1) = '#';

Simply increase the frequency to every minute. The job won't kick off again if it is already running, if you know what I mean.