My first thought is it the same version of DTExec on your machine and the server?

One thing I am reading about that particular error (0x800004005) makes it sound like error...

Since you are on 64-bit and Enterprise Edition, it is likely that the system is running out of  memory to process the data.

I would check things out on the server...

How large is the file?  From what I remember (and a quick bit of googling), SSRS doesn't limit file types by default and I'm not even sure it supports limiting...

Few things i would check before looking at upgrading from 2016 to 2017. My expectation is that upgrade won't help, but it might if it is a 32-bit vs 64-bit...

It seems that it is the two operators following each other "/-" that causes unexpected behavior (not the minus at the beginning).

SELECT -100.0/-100.0*10.0 => 0.1

SELECT (-1*100.0)/-100.0*10.0 =>0.1

SELECT -100.0/(-1*100.0)*10.0 =>...

• This reply was modified 5 years, 6 months ago by Mr. Brian Gale.

My opinion, that should work.  I see no obvious reason why it wouldn't work.

The only case where I can see it being problematic is would be if you set database...

Is sharepoint referencing the SQL Instance directly, or is it referencing the web interface?  If it is referencing the web  interface, then you don't have much to worry about as...

I personally have not seen that error before, but my first thought here is going to be either permissions or a typo.

First step that I would do is if you...

My first thoughts on this are that renaming a SQL instance is tricky and can be problematic.  I would recommend picking a name that works for the new server if...

I think the only way to limit this is to put restrictions on the linked server itself.

What I mean is to set the authentication on the linked server to be...

I agree with all of the comments.  To add to this though, if you want to search inside files and not use powershell, astrogrep is my tool of choice.

My process...

I think in this case if I understand things right, windowing functions are going to be your friend.

something like:

SELECT [site],
ISNULL([LCRate],0) as LCRate,
SUM([Eligible]) OVER (PARTITION BY [site]) AS...

My opinion (we run things on physical hardware with a SAN handling the physical disk, not VMs), and my understanding is that the datastore makes no difference; you want things...

To add to what Phil said, I think it also depends on what files you are storing in the database.  Are they plain text or are they PDF and ZIP...

As a guess, how much memory do you have free when you run that?  SSIS runs in its own memory space, so it is possible (and is my current best...