The sysmail_attachments is empty, it's only the the sysmail_mailitems where the problem exists(Size\Records\Space). I choose to stay away from dates and use the PK(mailitem_id) for the deletes. I ran a...

If you have multiple jobs running from the sql agent during the delete cleanup, do you think I'll run into locking?

Thanks.

Could you provide full example that includes the checkpoint and Wait?

Thanks.

I need to do the cleanup in batches that's why I'm supplying the min\max  in the where clause. I already have the blocks of mailitem_id's in which I will be...

Do you see anything wrong with this code? I'm wanting to do Batches of 10,000 and based on the mailitem_ID counter found in the table. I going to feed it...

If I wanted to use PS and Invoke-sqlcmd how would that fit with the SQL article?

THanks again.

I'm going to run the delete using the ID.

Thanks for the replies.

Just logging progess of the delete in PS.

Thanks. I looked at that sp and it uses sent_date(Not an index). I was hoping to use a PS script and the mail_id from the table

to delete the records in...

Thanks I have it working.

Can I self generate the headers and only retrieve the fields I need which the one with a comma within double quotes

isn't needed.

example of the header generation ..

Thanks.

I did go the route of a staging table and defining them as varchar(255). Now how can I take that schema and data

and validate against "Live" table field defs?

If I...

in the vbscript version you pass in the OLD DTS package and the server

so from a cmd script its csript vbsrun pgkname server

I know this is old but any ideas how to make this run?

PS:

$DTSSQLStgFlag_UseTrustedConnection = 0x100

$dtsapp = New-Object -ComObject DTS.Package

$dtsapp.LoadFromSqlServer(

$server,

[type]::Missing,

[type]::Missing,

$DTSSQLStgFlag_UseTrustedConnection,

[type]::Missing,

...

Is that the correct way from Batch to run the process?