It's quite bizzare i should say.

Switching to 32 bit option was a hail mary! pass after making all sorts of debugging on the package up to creating a new data...

it's a .NET provider and it uses the latest version of the MySql connection manager.

And the kicker is that this package has been executing no problem for months using the...

The package loads data from a MYSQL source into a SQL destination.

Uses an ADO.NET Source Editor. The error is at the data flow source.

Error message package executed in 64...

akin.akinwumi (6/25/2012)

---

See attachment.

This is a screenshot of a package (thanks denglishbi) that attempts to dynamically process only dimensions that have modified attributes. So you use a 'SSAS EXECUTE DDL TASK'....

See attachment.

This is a screenshot of a package (thanks denglishbi) that attempts to dynamically process only dimensions that have modified attributes. So you use a 'SSAS EXECUTE DDL TASK'. Using...

Using Excel 2007.

Drag your columns into the pivot as you need them.

to prevent Excel from automatically nesting the columns, do the below

Click on a column in the pivot

Go to...

jchernev (6/22/2012)

---

I worked around it - you can set the connection name inside the package to a dynamic setting. The downside to that is that you have to hard-code all...

It will be interesting to note the thoughts of the community on this.

The architecture I have designed and deployed goes as follows

1. An sql agent jobs that runs in 3...

I think without changing the Oracle source query you need to modify the default output property that SSIS presents the columns from the data source.

Select the datareadersource that contains the...

Ahh... we are getting there.

You did say that after running a dimension process folowed by a full process in Analysis services, you then reran the SSIS task successfully?

And from...

You've set up your question as a SQL problem. MDX solutions require a little fine-tuning and are not quite so straightforward as SQL solutions.

So without knowing too much details about...

Insert a 'Rectangle' item inside your reports. Then add a ppagebreak after each rectangle. In your case you will have 3 rectangles place the entire contents of each report segment...

opc.three (6/15/2012)

---

In my opinion that is actually the worst...

Did you execute in ssis bids?

See the attachement. You need to look at the warnings tab in ssis to get more info.

Your problem may be due to the way your database servers was set up and ssis performing row-by-row inserts vs mass insert using a sql query. Now what about a...