I can't use truncate, I need to delet over 5 mil records and leave about 2mil

Thank you

Yes I saved as SQL Server,

how can I call DTS package from sql job, I have previous dts package and not sure what the numbers mean, here is an example:

DTSRun...

I don't see this permissions/roll on msdb

Thank you

int

If I run WHERE (field1 > DATEADD(d, - 7, GETDATE()))

get error:arithmetic overflow

No,but I need

this where field1 > DATEADD(d, -7, 'getdate()') and field1 <= 'getdate()

Error:

Hello,

This is still not working

Thank you

He needs to execute more than one

This job worked before and I don't understand why it is faling now

Thank you,can you create SSI package on the another instance,because I am having dificulties,if not,how can I run it?

I re ran and it worked,but I wanted to know what happend at that time.

Thank you