HawardW you the man.. simples when you think about it...

one gets used to using bids as its fine for 99% of tasks one wants to do.. happily loading files now.

thanks

I read the articel many thanks for that, but it doesnt seem to apply to my situation. I am running the pkg from within Visual Studio on my local...

hi i have a loop running set to attach each file to a dataflow task and load it it runs really fast but after 4000 files or so it crashes...

i think i will try your idea of a temporary table containing just the unique fields I need in my join then create one record for each of these for...

Hi thanks fot the recomendation... inot sure ive found exactly what you are refering to (if its a book) but im on the right track thanks.

thanks for that i shall keep those points in mind! i was kinda hoping there might be a good DBA book that i should read to give me a...

why are we still waiting....  zzzzzzzz zzzz