Yes.

I have been unsuccessful using it with my expression.

Your revised script worked GREAT in SQLPS. Pasted it in. Ran it. Unzipped the files to the correct folder.

HOWEVER,when I used the same script as a Job Step, it...

Path checked out OK.

Revised the script somewhat:

$path = "\\Servername\SQLBackupsFromPROD"

$destination = "\\Servername\SQLBackupsFromPROD\CaaS_Backups"

$Extension = "*.zip"

$shell_app= New-Object -com shell.application

$Files = Get-Childitem $path -Include $Extension

#Format-List -InputObject $Files

foreach($file in $files) {

$zip_file =...

Have not tried the Log File trick. Did try capturing the Job Step output to a TXT file but it was blank.

I did log onto the box using the...

He assigns KEY numbers by CLIENT. Then he charges his clients based on number of licenses. Apparently when this instance was installed six months ago the installer used...

The SSIS package will reside on a SQL2008 server but it will connect to both SQL2005 and 2008. I have trusted connections across the board so all I have...

I really liked your script and find it quite useful. However it omits User Defined Data Types. Is there a way to script those as well?

Fred Woolverton

Gail,

Thanks a lot for all the information. There is no way to make any additional room on this disk as things are now configured. We will have to...

Gail,

Much thanks for the info.

The MP5 drive is 134 GB of which 5.1 GB is free space. The ndf file referred to in the log is 22GB.

I get this message in both event viewer and the SQL Log:

Event Type:Error

Event Source:MSSQL$*****

Event Category:(2)

Event ID:17053

Date:1/16/2009

Time:1:30:28 AM

User:N/A

Computer:

Description:

P:\DG1\MP5\P____S_LABCORP_20080901_IN_D1.ndf:MSSQL_DBCC9: Operating system error 112(There is not enough space on the disk.) encountered.

If...