Getting a 404 on...

Please encapsulate your code in IFCode markup. It makes it so much easier to read as it preserves formatting.

I would also not suggest the ISNULL in your WHERE clause, but...

Yes, you still have 2016 installed (it's just acting like 2012), which is different to actually installing 2012.

Using a script task was exactly what I want to avoid 🙂

BrainDonor (12/19/2016)

---

I suppose getting csv files sent isn't an option? It shouldn't be of course but I've already ranted about the delight of Excel files with SSIS in the past...

Thanks Phil,

I got to step 4, and my error rows were about half of my data set. Exporting that data out showed nothing odd about it, but they were all...

DamianC (12/19/2016)

---

Thanks, that is pretty simple!

How does it handle schedules

I see it generates a schedule using @schedule_uid with a uniqueidentifier

If I script out the job, change the name and run...

I can't say I've encounter it before, but I would have thought this is quite simple to resolve.

Without the table this is guess work, but would this not work?

ValueColumn /...

You can add permission denied to your SQL Server logs by using:

EXEC dbo.sp_altermessage 229, 'WITH_LOG', 'true';

I have, however, noticed this doesn't give you the user name. However, if you have...

Phil's definitely is cleaner and faster, but yes does depend if you want to introduce a different language. Personally, I find Phil's very easy to read, and I don't write...

How active is your table going to be? Is it going to be in constant use? Are rows likely to be added to your existing dataset while you're trying to...

When you say Dim Tables, are you talking about your Dimension Tables (stored in a SQL database), or your Cube Dimensions (which is stored within your cube).

Tables, on SQL Server,...

This gives the expected results:

SELECT C.Id,

C.[value] AS CurrentValue,

C.valuedate AS CurrentValueDate,

...

That's one way of doing it yes.

If you didn't want to use a Script Task, you could use a For Loop container and then assign the filename to a variable...

You're trying to grant a user permissions when you do not have permission do do so. The db_executor role I gave you gives the user permission to EXECUTE, which was...