Phil,

Hi.

First off, thank-you for helping.

Your 2nd to the last reply got truncated..... There was no link... it was just:

You might find this...

Phil,

Your last comment confuses me.

I gave you my environment (Data Flow Task / OLE DB Source / SQL Command text)

I gave you the code I ran ( exec sp_paceused)

I gave...

Thank-you all.

When I just run

"exec sp_spaceused"

This is the error I get:

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at Data Flow Task [OLE DB Source...

Sir,

Good Morning.

Great article. I've been searching for a procedure like this for awhile !

A suggestion:

The constant creation and dropping of table PHYSICALHOSTNAME against the master database has the potential...