You need to read questions properly before answering. Three times I stated the question and three times you have gone off on a tangent.

Thanks for the info but I beg to differ on not getting any performance gains by partitioning. By partitioning I will not have to reindex the entire table...

Hi Gail, Thanks for the response. I understand that partitioning does not occur on age but date. I also understand having the partitions in separate files has the overhead...

cheers, that'll do.

Often running a package in 64 bit mode will throw that error. If your package runs locally, check whether it is running 64 bit or 32 and ensure it...

I suggest you type the command directly in the command window and notet he output.

To verify whether it worked or not after the process task is executed check...

The timeout settings are a server side property so they must be set on the server as you establish a connection but only if the ODBC driver allows you to...