No idea, haven't tried this myself before.

Maybe BIDS is using cached data when you run the report.

Make sure all the .data files are deleted before you run the report again.

Another option is to use XSLT to transform the XML file to an easier format, such as .csv.

An example:

Loading Complex XML Using SSIS[/url]

There's almost no difference between 2008 and 2008R2 in SSIS and I would be surprised if 2008R2 introduced a bug that isn't fixed yet.

So I would look into another direction....

SSRS doesn't support text files as a source, so you'll first need to get the contents of the text file in a place you can reach with SSRS, preferably a...

If you process your cube daily, you could put a view on your time dimension.

The view simply adds a column that calculates for every day the relative position towards today.

For...

I would do this in a script component by using the .NET parse method.

Doing this in a derived column would be too complicated.

Very useful article, thanks.

Nice basic question Ron, thanks!

Nice question, thanks.

Great question, had to read it a few times.

Normally this would be done through FTP or a web service, but I assume you don't have control over this.

You can try with a HTTP connection manager:

Downloading a file over...

Read the part Understanding How Package Configurations Are Applied at Run Time

Package Configurations

The dataflow task cannot handle changing metadata. You would need a different dataflow (or source/destination pair) for each type of resultset.

Maybe SSMS uses the SQL Server account to run DTEXEC instead of your own account?