nicely done. thanks for posting the solution. it is always nice to see this type of contribution to the forums and much nice than just seeing a 'we...

what about moving packages? are you experiencing issues or looking for best practices? how are you using packages currently - database or file system? what additional items...

Nice. Good job and yeah I forgot that you needed to reference the 32 bit dtexec so using the cmdexec instead of SSIS execution was the way to go.

That would do it. Nice catch on the extra reference not being available and the squiggles should have been there to see that the reference was not available. ...

I have found that opening the script tasks on the 64 bit box with the precompile set to true does the trick. Kind of a pain I admit and...

Are you receiving this error message when you try to connect by using the Reporting Services Configuration Manager? I am assuming so, but just trying to get some more...

Are you trying to create another attribute for the dimension to show number of days or a calculation in the cube to handle this. I am not sure why...

Within SQL Server under Security you need to create credentials which you will then use when you setup the proxy under the SQL Server Agent for the SSIS package execution....

Very interesting article. Always neat to see how other people go about solving problems and coming up with solutions. I also had to deal with getting SSAS data...

In order to perform the following steps:

1. In the SSAS Server instance properties change the value for the directory with the new location

2. Stop the SSAS instance

3. ...

It might be helpful if you post the actual command that you are running so that we can evaluate it. Also, which version of SQL Server are you running?...

If you are using SSAS security and want to pass the user's credentials to a SSAS instance that is not on the same server as the Report Server you will...

You can run a trace against the SSAS database with Profiler to get at the MDX, but it is going to be broken up into session sets as you drag...

You can loop through the files and with variables you can set the connection string for the source to perform a bulk insert. If you are going to have...

When using SSAS as a data source for SSRS you should be getting a row for each record, so you should be seeing a date and country record for each...