There are many ways to do something, and then the right way.

Your way works but will not scale very well. The overhead it causes is unnessasary. To be frank, it's...

rather just use profiler. Don't ever fiddle with system objects.

let us know how things go...

I would not use that. Creating a temp table for the sake of a a SK it serious overkill and will kill performance.

Simply install the row number component and use...

Sorry.

Go to http://www.SQLIS.com and download it free.

I would say try stagger the schedules by 2 minutes or something like that. Might be a bug with all the packages kicking off at the same time.

I would assume...

A starting point would be to use profiler to capture a days work (Use the Performance Tuning template) and then get the Index Wizard to analyse the data. This will...

Try reducing the buffer settings in the data flow slightly. (Reduced Performance though)

How much memory you got in the machine?

Very weird error.

Do you have all the patches or Sp2a installed?

Does it only happen when you are using Agent to run the package?

Do that other packages that fail connect to...

You could either use an Identity column in the SQL table, or use the Row Number component in SSIS. Both will give you a sequential number which you can seed.

How terrible is the acting in the video. DBA's can't be actors (Even though we do it on a daily basis )

They are fellow...

Glad I could help. It's a hint that you should look at improving the index, bearing in mind inserts / updates etc.

Look...

Most probably, and you would have to look at the execution plan (The pretty picture one I like :blush

In SQL 2000, if you sort...

it would appear that to has ODBC drivers.

http://www.google.co.uk/search?q=advantage+odbc+driver&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB213GB213&aq=t

I'm working from a hazy memory here but as far as I remember, it was restricted but I seem to remember a way to override it. Have a scratch around...