Hi Jeffrey

In some semblance of order:-

That's fine, read-only is fine for what we need (not sure why I wrote read/write in my original question).

We use SSIS for program flow but...

Assuming you are logging all the runs (I think that's the default), you can have a look in the reportserver database.

The Catalog table holds all the reports.

You'll also need to...

Option 1 may well work, but in this instance, it's renaming the wrong field so is wrong for the question posted.

(I know, I'm being really picky now).

• This reply was modified 5 years ago by  richardmgreen1.

Two small gripes on this one.

Option one won't work as it's renaming the wrong field.

Option 3 also won't work (as mentioned above) as the originating field name is different to...

I found it.

It had actuially been renamed somewhere (I had to look in the XML code for the DSV and search for that table, then it gave me the friendly...

I'm not sure.

It exists in the tables I can find, but I can't find the table that's throwing the error in my OP in the DSV.

Thanks Jeff

Looks like we'll have to dig into the SSIS packages then.

I wonder if it's a date format setting that gone a bit strange......?

Richard

In the examples I've given, I'm not passing a NULL value (or 01/01/1900), it should be picking up the correct date/time.

If you have a look at the code I've supplied...

I thought I'd attached the SQL but apparently the forum doesn't like it (it's been blocked due to potential security risks).

I've renamed them to *.txt files to see if these will...

Just as a quick note, we do something similar but we use the configuration manager to store the server and initial catalogue values.

That way, it doesn't care which server we're...

I wouldn't call 160 massive and this works for us.

We do spawn up to 32 versions of the same SSIS package to do the loading but, if one were to...

We do something similar to import 160 text files (and we get these every day).  They are pipe delimited but have a .CSV extension.  Each file has a different layout...

I know this this is an old thread, but thought this may be worth a mention.

I have the same issue on a SQL2016 / Windows Server 2012R2 box.

I'd tried everything...

Thanks all.

Looks like we're doing things the right way then.

That's what we currently have.  We haev a job that recreates the roles on a schedule but that doesn't alweays run (a different issue).

We were looking to do this the...