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, 5 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...

@Phil Parkin,  simply a query which removes them from the rows that are selected.

I don't have any CREATE statements. I am just selecting rows from CTE.

You have >600 points, so...

By 'remove', do you mean you want these rows deleted from the database?

Or simply a query which removes them from the rows which are selected?

Please provide your sample data in...

GETNOW()? Do you mean GETDATE()?

Sounds like you're having a lot of fun with this one!

If you know the following two pieces of information:

a) How many chunks are required

b) How many rows are in the...

No worries.

If your intention is to make this completely dynamic, such that the usual inputs the table name and the desired number of chunks as a parameter, you are going...

This is an interesting one. This is what I would try, I think:

First, change the way that the file-naming works. I'd use a static file name (somefile.txt, or whatever), and...

HECK NO! I am not the same person as that weirdo spammer posting things about  hair removal after my sql server post.

FYI!

I am a real person as is pretty...