i got this from this article http://www.mssqltips.com/tip.asp?tip=1426

DECLARE @DBInfo TABLE

( ServerName VARCHAR(100),

DatabaseName VARCHAR(100),

FileSizeMB INT,

LogicalFileName sysname,

PhysicalFileName NVARCHAR(520),

Status sysname, ...

hi, i am doing your script in your article and it works great, now is there a way to run that script against different servers in an ssis package? if...

hi thanks, my issue is I attempt to connect to an instance of Integration Services on a remote server, and the server responds with an "Access is denied" error message....

I am trying to connect to my server's SSIS through my local machine. I am not sure i understand your solution.:ermm:

indeed it was a permissions issue! thank you soo much!

i get no errors, in the job it comes out as ran successfully.

thank you! I did read the article I think at this point i will go for a much simpler solution just to get the disk space usage to create reports...

Has anyone been using this script and has been working for them?

hi for some reason i always get the growth size to be 0, do you have an updated script?

thank you all!!!:)

hi thanks for your script, does your script do the same thing create a table with all the metadata information from the system tables?

thank you!!! 100 GBs

so for now since i don't have the existing script and i will create it to use it in the future. what would be the ideal way to know how...

thank you!, no i haven't i guess is never too late to start! 😀

thank you!