Well the processors seem good, RAM seems a little low but probably ok..

32 or 64-bit?

Local drives or SAN?

RAID array? What raid level?

Are the OS drives on seperate disks from...

Why don't you tell us about the destination server.

If they have varying destination paths then no it wouldn't make sense. The config files are best for things that are static and need to change at the beginning...

I would add a second step to the job that called the first package.

CEWII

Since it sounds like you are sharing config files I would create seperate files for those. If you don't then every package that runs that doesn't have those same...

What is the data source?

Same server/different server?

How complex is the query used to generate the data?

One of the things I've seen is the source isn't returning rows fast enough to...

You are very welcome.

CEWII

I had looked at this in both SQL 2005 and 2008 and the column list is not enumerable in a script component without using a REALLY convoluted .Net reflection process....

There are a couple things in play. Does your package have embedded passwords in connection strings? If so, unless the package is executed as the user who entered...

It is really easy using those classes.. REALLY easy..

CEWII

I think I would seriously consider using the script task and use impersonation to handle this.. I generally try to prevent depending on other things in the file system to...

Although I can't speak directly to 2008 I know that it was a problem in 2005. I'd probably set the sizes and disable auto-grow.

CEWII

I completely agree, it is VERY often permissions. And absolutely the first place to start..

CEWII

I was trying to avoid recommending a SQL re-install but I wouldn't be surprised if that is what it took..

CEWII

Your apprehension is justified. I *might* be more inclined to do this for a user database, resistance would be harder to justify, but system databases, not even for a...