MDX source data to OLEDB destination in SSIS?

So once I was working with my usual SSIS packages and this time the source specified was fetching data from MDX. During the testing phase, everything went well and the staging ETL went smoothly as expected. An SSMS job was created for calling this package everyday.

After a few days, we realized there was something wrong with the data.The data populated in the stage table was very selected. For example if the MDX specified 3 years worth data, then only the data for 2 years would get populated. This was quite a mystery for us knowing that the job was running as scheduled and the MDX was bringing data once run separately. After some rnd, we found the following as our solution :-

Previously, I had simply used "OpenRowset" which was truncating some data. Changing this to "OpenRowset with Fastload" solved everything and I haven't faced that problem ever since. 

Pilot

So being new to blogging, all sorts of random ideas which turn into nonsensical rants (in my head) cross my mind. From SQL Server to professional environment experiences, from certifications to just plain blah, all could bring in some sort of  flavor. I could talk about the following though.

1. Experience with SQL Server 2008 R2
2. New functions in SQL Server 2010
3. My queries about Big Data and Hadoop
4. Other problems that I solved using my genius