Put a breakpoint on the task Archive File on Pre Execute, and then look in the Locals Pane and explain Variables. In there you'll find the Variables for your task,...

Those are the names of the variables, not the values of the variables.

The error tells us where to look, but we don't have access to your package, so that doesn't help us much. In the File System Task Archive File, what are...

We're missing the SQL, so I can only show you an example. I suspect that you also want to ensure that any ' in the value are correctly escaped, so...

• This reply was modified 6 years, 5 months ago by Thom A. Reason: Missed out a qualifer on a column, whoops

Or, remove the service account from the users in the database and then add the service account as the new owner:

USE YourDatabase;
GO

DROP USER YourServiceAccount;
GO
EXEC sp_changedbowner 'YourServiceAccount';

Sorry to hear that your son's team fell through, but seems that he's on the right path and trying out for a new team. Good luck to him and I...

In a word; no. Considering that a backup...

I'm not really sure I understand what you're after here; what do you mean you need to upload a PDF to SSRS? What is your end goal here? Why does...

I assume, therefore, that none of your objects are in Source Control for you to easily create a script from? Have you searched for any solutions to do this, there...

Considering the OP is using 2016, they have access to DelimitedSplit8k_LEAD too: https://www.sqlservercentral.com/articles/reaping-the-benefits-of-the-window-functions-in-t-sql-2. I don't really, however, see the point in using a splitter when there are only 2 values...

You can't have multiple columns with the IDENTITY property. Why would you need 2 anyway, as even if you did, they'd have the same value. If you want that value...

Couple of options using PARSENAME and CHARINDEX:

SELECT PN.debtTypeId,
       PN.ratingTypeId
FROM #test T
     CROSS APPLY(VALUES(PARSENAME(REPLACE(T.Type1,'|','.'),1),PARSENAME(REPLACE(T.Type1,'|','.'),2))) PN(debtTypeId,ratingTypeId)
WHERE PN.debtTypeId = 31
...

Just noticed that in SSMS 2018 there's a little Tux (the Penguin) next the database icon now if you connect to SQL Server on Linux. Not really sure it was...

Why do you believe that memory is the problem? If users are complaining of slow performance I'd first be checking things like the query plans for the queries that they...

What surprises me is the amount of bad restrictions that on some applications for passwords. A bank I used to use only allowed up to 12 characters for a password...