If they all have the same structure, I would use UNION/UNION ALL to make them a single dataset.

What problems are you having passing the parameters?

mjbriggs03 (5/8/2012)

---

Hello all,

I have the following query in SSRS...

SELECT

a.JURISDICTIONCODE,

a.NAME,

to_number(REGEXP_REPLACE(REGEXP_REPLACE(b.value,'[a-zA-z]',''),',','')) as "Population"

FROM

DLSGATEWAY.JURISDICTION a,

DLSGATEWAY.SE_DATA b,

DLSGATEWAY.SE_DATA_VALUE_TYPE c

WHERE

...

Charlie Sheen

Interesting count & count_big. Learned something today. Thanks.

Using 1 - 3 - 5 Mondays, you will get the 5 & 1 two weeks in a row.

I don't have standard version so I don't know if...

Gorgon

sam.dahl (5/3/2012)

---

This is an...

Most transforms have a setting on how to handle an error, set it to ignore. I would use package variables and a count transform to get your row counts.

My first questions would be have you patched or upgraded recently?

What does your data look like now?

Ahhh.:smooooth:

I think RunningValue scoped to your group would do the trick.

I have an idea for a different approach. It would take a little effort to set up, but way easier than a parallel environment.

-Set up some kind of user...

One other thing you can look at, althought I have not tested it for this purpose. In the flat file source editor on the connection manager tab there is...