No, developer isn't free (but also not expensive (under $100 if i recall correctly). But you really need to decide on what you're trying to achieve. you can't...

Yep, everything, to the extent that if you try and run it ont he same server/instance without changing some names, it'll fail (because these already exist).

This sounds like a reasonably good use case for STreamInsight - came out in 2008R2, still there in 2012 and 2014, can't speak to it's true longevity in the product...

In what context??

As a general statement, all dimensions are database dims but not all database dims are cube dims.

Is your service installed as an instance, or the default instance?

Yes (but, being pedantic, there wouldn't be a 'delete' per se on the dimensions. you might flag a record but deleting isn't overly fun, then you need to del...

I'm sort of not going to answer your question directly, but hope that you might get what you want indirectly 🙂

If you're working with say Student, Course, Room etc -...

When you say the data in them could change any day, this is true of many slowly changing dimensions, but we don't rebuild these daily. Typically the key...

To ensure I fully understand - you're completely tearing down your dimensions, rebuilding them (hence the new keys), on a daily/load basis?

If so, not much you can do other than...

Hi Jose,

Bit of a known issue. Seems the best work around is to create two copies of your template and then file copy the empty one to the directory...

if you're now trying to use the copied out xml (from within the package), then try saving it as an xml file, ensure you have root element in there, and...

If you open/edit the dtsx (in say notepad++) and then search for <DTS:Variables> you can take that entire section. You'll need to do reformating to make it work nicely...

Hi baddulas, I've got the package but honestly dont have time to modify all the components to be able to test it.

A quick search shows that return code 9 from...

If you don't want to hard code the path into the outer batch file, set the WorkingDirectory property on the ProcessStartInfo object

StInfo.UseShellExecute...

Definitely modify the expression on the @Arguments variable to have the space between the two file names as Eirikur pointed out, you can't have the parms run onto each other...