Both UserId and NT Account are unique index and UserID is clustered. And yes, NT Account can be changed anytime for a particular user specially for females who just got...

Thank you, guys! It made sense to me. I will raise this up to the app developer. =)

I WAS ABLE TO FIX IT BY USING THE CODE BELOW:

=IIF(INSCOPE("Group1"), Fields!CURRENT.Value, IIF(Fields!MonthEndDate.Value = "11/30/2012", SUM(Fields!CURRENT.Value), 0))

NOW MY problem is I am getting 0 result only.

I don't know what...

So I have tried this one:

=SUM(IIF(INSCOPE("Group1"), Fields!CURRENT.Value, IIF(Fields!MonthEndDate.Value = "11/30/2012", Fields!CURRENT.Value, 0)))

but I am getting an error "#Error" on the cell.

Any idea how to fix this?

Appreciate your help!

I assume that the columns you are referring to varies from table to table, correct?

If this is the case, I don't think SSIS can handle dynamic "formation" of columns. You...

Hi!

So I talked to the DBAs and for some reason they just couldn't run the package on design mode to have a detail look on what data is going in...

Thanks!

I have emailed the DBAs already and they are still looking for it but based on their initial response, the files in there have the correct naming convention. They sent...

i think i know the culprit but i wanna make sure first...

in the dimension table there's an attribute named Fiscal Year and in the hierarchy there's also Fiscal Year.

Is this...

sorry bout that, the query is below:

select

[Measures].[Time Entry Hours] ON COLUMNS ,

[time].[fiscal trans date].allmembers on rows

from [sa]

the time is the dimension and the hierarchy is the fiscal trans...

Koen Verbeeck (5/31/2011)

quasar_phoenicis (5/31/2011)

I have a parent package with 2 execute packages tasks that are connected through a "success"contraint. Execute SSIS package 2 should not run until execute ssis package...

Hi,

I have a parent package with 2 execute packages tasks that are connected through a "success"contraint. Execute SSIS package 2 should not run until execute ssis package 1 is finish...

wow! great! didn't know this one. thanks a lot for the help!

hello,

i came across the same problem. I have an OLEDBSource for DB@ with a simple select statement in it. however when I try to click the parameters button, i'm getting...

just curious, by "do the conversion in the database" you mean using sql script? I am really not into databases but is there a way that I could do the...

nice! that solved my problem. thanks a lot!