Can you confirm that your DbaTools library is stored in the same location as found when running the following?

$env:PSModulePath -split ';'

(As I think some file locations differ...

Something like this?

WITH CIds
AS (SELECT ChannelID = CAST (value AS INT)
    FROM STRING_SPLIT(@ChannelIDs, ','))
SELECT dc.*
FROM #DeviceChannel dc
    JOIN CIds
  ...

You are right in suggesting that a CTE won't work in this case.

You might want to try experimenting with SYNONYMs. Aliases are limited in scope to the query in which...

p.s.  I followed your "casing" in my code but the "prettifier" in the code window changed all the SQL Code to upper case for display.

The SQL code is not all...

Thanks Ant-Green,

Ok, to ask a dumb question to clarify, I should install VS (either 2019 or 2022) I then go to manage extensions & download/install the SSIS/RS/AS packages.

I should...

You mention that there would be a lot of changes required if you change the format of the column. But wouldn't there also be lots of changes required to use...

Yes, but...

I've just reported one of those AI-generated "SQL Server is good because" essay posts as spam. Do others agree that this is the right thing to do?

As you have not provided the logic for your 'business month end' calculation, I'm not sure how you are expecting anyone to calculate it.

EOMONTH() gives you end of month for...

Are you certain that access from server B has been configured correctly? You can test this by changing the default creds in VS and redeploying to server B.

The standard way...

I can't see anything wrong with what you are trying. Are you able to access Server B from VS, using the same credentials as you typed into SQL Agent?

I'd try to understand which rows have been lost. Given the volume of data, this will be a pain, I know. Is it always the same rows which get dropped?

Once...

• This reply was modified 2 years, 4 months ago by Phil Parkin.

Glad to help. It would be interesting to hear how your streaming solution performs when compared to other methods, so please post back if you get the chance.

Thanks, and yeah GETDATE( ) or actually NOW( ) would be basically correct, I believe.

Note I have worked with so many languages sometimes the exact function names get a...

Edit your package in VS and change the definition of the flat file destination so...