specifically in the ELSE Case I get

Error in list of function arguments: 'SELECT' not recognized.

Error in list of function arguments: ')' is not recognized.

Unable to parse query.

I would...

I'm having trouble with the following bit. I have a fairly complex set of case statments but the following is what I'm having trouble with (most inside portion)

...

Thanks for the Links! Here's what I found. per a conversation in one of those links, someone changed their int32 type to long to make it work.......

I think I see something that may be of issue but I'm not sure why....

SSIS package "DataPullTest_Score_D.dtsx" starting.

Information: 0x4004300A at Data Flow Task - Pull Data from District, DTS.Pipeline: Validation...

error is on the Execute SQL task.

Ramesh (4/6/2009)

---

When did you get that error? Is it on executing on the package or parsing the query? (I think later is the case here)

Try setting the BypassPrepare=True...

I did and pushed it to User::InsertVariable (string) and it came up as follows:

Exec usp_InsertDataPullRecordCounts 'Test_Score_D', 0, 174227

which looks correct to me, (and inserts just fine in a sql...

Perfect! works great. I knew I...

I finally solved it by creating a series of subreports and creating a table to locate them in and grouping the table on the ObjectiveID.

worked really slick.

yes I'm using VS BIDS....

I'd have to agree with you about Access being a simple reporting tool.... and I also have see situations where it would put the "Texas...

correct where each break would contain a different objective and the details therin as well. and a dual column results | use of results.

I can almost get my mind...

the query isn't an issue, getting the data is easy. what I don't see is how to get it into SSRS Reports.

here is the pattern:

for each objective

Display...

I didn't have any issue with data sets until I added more than 2 to a page (1 for the param listing) and one for the displayed data set... ...

does shuffling down the hallway to the coffee pot count?

Winter - snowboarding

Summer - wakeboarding & jetskiing with my brother

Fall/Spring - Frisbee golf (cause I can take my dog)

for a...