Doable with Excel and SSAS. THere's a video floating around somewhere that demo's this.

You're missing single quotes, assuming you're trying to insert to MSSQL.

"insert into errorlog values ('"+(DT_WSTR, 20)@[System::ErrorCode]+"', '"+@[System::ErrorDescription]+"')"

Out of interest, why not just use the log providers built into SSIS? There...

Definitely doable - see here ..... http://www.sqlservercentral.com/Forums/Topic786526-147-1.aspx

HTH,

Only just scanned your code, but if you're doing a RIGHT oin the filename, remember, you have ".csv" in there. There's a lot of ways to get around this,...

Just for fun, or debugging purposes, i tend to run queries like this in the following way until I can see that i've ironed out the issues -->

select ...

derived column instead? use what you had previously ISNULL(Date1)? 0:1 + ISNULL(Date2)? 0:1 + ISNULL(Date3)? 0:1 + ...... and the resultant value is the count of not null...

Your example doesn't indicate this, but you may be seeing the aggregation at the parent level of children that you weren't expecting. This blog post[/url] shows this reasonably well.

and google Bill (or WIlliam) Pearson III and pick the link (top 5) that points to sql database journal. He has several (in the 10's or maybe 100's) tutorials...

After the day I've had with SSIS today, i'm with you on that one!

@robin - A very small change to my original post gives you what you want with significantly less code required. I've pasted it below.

Personally, I'd still be...

You need to provide more detail/s on exactly what you're doing and then what is happening - ie you're connecting from Excel to AS2K8 how? Using the From OTher...

this takes me back ... 🙂 I think the axis files are related to dimensions, large dimensions. Corresponding with the increase in time has there been an...

I'd say it's the default measure. Believe there's ways to see this in the properties but you can also prove it using the following:

select

Measures.DefaultMember on 0

from

[Adventure Works]

You deployed to a different server?? Have you checked (say via Report Manager) that the update/last modfied date on the Report is showing the date you thought you'd deployed?

You set them both to?? Int? Just interested to know if you did blow out the small int size and set it to something larger.which ended up...