Are you doing a full process, or an incremental process?

If you do a full process of the dimensions, the cube will be taken offline until you process the measure groups.

[font="Courier New"]DECLARE @VARCULTURE NVARCHAR(5)

SET @VARCULTURE = 'es-ES'

DECLARE @val NVARCHAR(100)

SET @val = 'data(/OPTIONLISTS/LISTNAME[@CULTURE="' + @VARCULTURE + '"])'

SELECT Localisation.query(@Val)

FROM dbo.Asset_Lists[/font]

On a side note, this is...

I assume your package has a step to create the table and a data flow task to fill it.

So, the package is failing after the table is created but before...

Stores procedures in Analysis Services do not do what you are thinking. To access a cube for reporting you need to use MDX.

Reporting Services will allow you...

Did you generate a snapshot? You have to generate a snapshot for the DDL to create the procedures to be generated.

This:

SQLQuery = "SELECT * FROM Leave, Dates;"

is simply going to crossjoin the two tables and give you a single recordset.

You need to open two individual recordsets. When you execute...

Caching if any rows exist in a table does not seem like it would be very useful. Why are you trying to cache this information? What caching mechanism...

For simple situations, you can control transactions manually.

1) Add two Connection Managers for connecting to your database. I am going to refer to them as "CMData" and "CMError"

2) On...

By the looks of your included T-SQL, you have gone about this in the wrong way.

Please post the entire SQL statement, the DDL for the tables, and some sample data...

Hard-code a T-SQL statement into the SQL Command of the Data Reader. Preferably one that will run very quickly (TOP 1 helps). The expression will over-ride this when...

That is not nearly enough information to help you.

You cannot use a variable directly in the DataReader SQLCommand. You will need to use an expression on the data flow component. Just set the SQLCommand to your...

I'm glad I'm not the only one that does that

I'm with Grant on this one. I know you said something is happening dynamically, but at the time of creation, something knows the field names. You are either...

Since what you are doing is pretty much a type-1 SCD, this site: http://www.sqlbi.com/%5B/url%5D will have some tips and some tools to help.