I was having the same issue, and no matter what I tried the header just wouldn't show up when I "previewed" the report in Visual Studio.

TD IS RIGHT. DO NOT...

One of the only sure fire ways to get an empty line to appear in almost all formats is to use the ASCII characters, for instance:

"string" & chr(10) &...

Visual Studio crashes. That's what it does.

Sometimes, it just takes a really long time to run massive packages (especially during the validation process), and it will hang if you...

Never mind that last question, I managed to find an answer at the following site for those who care:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136846&SiteId=1

Thanks for the help, Lucky, but now I have a trickier problem (I think).

I am using SPs to pass the parameters to each dataset for this scenario, and it goes...

Usman,

I recently went through the AS crash course as well, and I found the following site very helpful:

http://www.databasejournal.com/features/mssql/article.php/1459531

There are a variety of lessions/tutorials on MDX and AS that...

In regards to your first question, I do know that 2005 Integration Services can be used to process/refresh AS cubes. I also know that these packages can be kicked...

That did it!

Thanks for your help Joseph!

I'm not exactly sure I understand what you are trying to do, but I did run into something somewhat similar with hierarchies that vary in depth. While the parent-child...

I know this is a generic response, but make sure you have at least SP 3a installed. This is usually one of the first recommendations you get around...

For those who care, that is essentially how I solved this problem.

In SSIS, this means I used a Data Conversion task to convert both, then a Derived Column to combine...

Are you saying that you have each Month name as a column? Because I don't understand why you would do this.

Also, do you have any facts in this fact...

I also received a suggestion to use the "Ragged Right" file type instead of fixed-length.

I haven't tried it yet, but you may want to.

I do have it working without the derived column, now.

If you just edit the Flat File Connection and add another column that is two characters wide, you can just choose...

If anybody can actually figure this one out, great.

But for now I've just used a SUBSTR function in a Derived Column task to get around this, so...