Are server A and server B in the same domain?

Ugly, but this works:

DECLARE @SchedStart VARCHAR(25) = '2020-06-07-12.30.00.00000';

SELECT @SchedStart
      ,CAST(STUFF(STUFF(STUFF(LEFT(@SchedStart, 23), 11, 1, ' '), 14, 1, ':'), 17, 1, ':') AS...

If there are multiple different values for 'result' in any particular grouping, which one of those would you like to return?

If you've got SQL Search at the ready, try searching SSISDB procs for the text 'EncryptByKey'. I think that will indicate most, if not all, of the encrypted columns.

Out of interest, what do you mean by 'does not have the master key open'? I've never had to deal with anything like that.

Here's another way

DROP TABLE IF EXISTS #Stuff;

CREATE TABLE #Stuff
(
    SomeText VARCHAR(1000) NOT NULL
);

INSERT #Stuff
(
    SomeText
)
VALUES
('ID=205&SID=1005&TID=3')
,('ID=25&SID=1005&TID=3')
,('ID=2&SID=1005&TID=3')
,('ID=2006&SID=1005&TID=3');

SELECT s.SomeText
     ...

Please read this for details of how NOLOCK can make things go wrong.

I was seriously considering setting up a consultancy yesterday and offering my services to HM Gov at a fixed fee of £20m to set up a process using punched...

Can I replace them all with a single SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED?

Yes.

Should I replace them all with a single SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED?

No.

At least not if...

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

If you post screenshots of your DB connection manager settings and of the OLEDB source config, we should be able to work out what is going wrong.

Unfortunately, the error message...

Thank you for the replies. I have tried OLE DB Source, but it failed on preview. I do see the result if I run a simple SELECT  myClumn FROM...

You've been here long enough to know this...

If you want a coded solution, please provide sample DDL and sample data in the form of INSERT statements.

Does anyone know of a way to only deploy a single package between 2 SSIS Catalogs -- NOT using Visual Studio's package deployment feature.  I want the version of...

Not sure how you want the output formatted, but does this help?

DROP TABLE IF EXISTS #Stuff;

CREATE TABLE #Stuff
(
    StuffId INT NOT NULL IDENTITY(1, 1)...

You can use MAX to make this work:

SELECT t.ID
      ,MAX(t.LegalName)
      ,MAX(t.City)
      ,MAX(t.Zip)
FROM...