100,000

from the Indian numbering system, quite common depending on where and who you work with...

http://en.wikipedia.org/wiki/Indian_numbering_system

As for the formatting if you...

I don't really see the point in digging up a topic from a week ago to repeat the points already made, you need to give the guy a break..

if the files have a different format or different number of columns then you will need a sperated data flow for each,

yes that is the correct approach , loop through files that have the same structure,

for files with different structure you will need a sperate data flow. this may mean...

you need to group the files that have the same structure together and loop throught them, then have a different data flow for each set of files that have the...

one of the errors relates to storage, have you checked this?

I would never automaically change the compatability level ot 90 after an upgrade as there is too big a risk that some application will fail to function in Level 90.

Test...

I would say go for it, at worst it will cost a couple 100 ££ and a bit of time.. at best it will help you learn things...

yes you should keep all your servers up to date with the latest SPs as a matter of best pratice

download the Adventure Works DW and Cubes from codeplex, this will give you a chance to see how a cube is built, (building a SSAS cube follow the...

have you addressed the issues that are in the log?

so the package keeps on running but no data is written to excel?

is it possible that you are writing a huge amount of data and it needs to take time?

perhaps...

churlbut (3/31/2011)

---

I don't see a reasonable use for Check Constraints. I have pre-process validations I perform before doing major processing, I will mark records as error if the fields...

1. yes.

2. no - I usally find performance problems are related to poorly built queries/tables rather than server type

3. about 18mnths

I have, didn't really have any challenges that were specific to Virtualisation as the server is presented in the same way as a physical server and the setup...