Good point

Assumed that course would be enough, but Report Development is a big part of the training requirement, so will have another look

Cheers

Thanks - I'll have a look

Todd McDermid (7/6/2011)

---

I think a terminology mistake is causing these replies.

You don't have "50 flows" in your data flow, you have 50 components.

50 "flows" in one Data Flow Task is...

ZZartin (7/5/2011)

---

And yes 50 dataflows in one dataflow seems...

Koen Verbeeck (7/4/2011)

---

I'm afraid not, SSIS is strongly typed about its metadata.

On a sidenote: isn't a dataflow with 50 flows a little too big? Can't it be split into smaller...

John Mitchell-245523 (6/15/2011)

---

If you already have a package configuration in your package, you should be able to edit it. Click on the Edit button and change the configuration type...

Neither Code runs very well - Cancelled both after 10 minutes..

Your first code snippet works - Would I need to run DBCC UPDATEUSAGE before I ran it?

What would I need...

How would I incorporate that code to count the table rows? :unsure:

Ignore - Hadn't ran the code!!

Is this an estimate or the exact number of rows, read somewhere about DBCC...

There are a few hundred tables and I only need info on about 50.

Looping through an extra 150 tables (some of which are quite large) would take too long.

Also, most...