I had this problem until about 45 seconds ago.

Turns out I had a superfluous group on the row level. If you're reading this, take the time to...

@HoursForward variable is not defined in the script. Needs to be DECLAREd and can't be 0 if you want results.

Also, [LastSuccessfulExecution] seems to be broken. Showing "Never", when...

Thank you ib.naji. Just looking for ideas at this point. Always on, will check that. Ad-hoc Linked Server queries just don't seem to be working.

It's starting to...

I've gotten this command to work inside a script object:

Public Sub Main()

Shell("c:\documents and settings\sqladmin\desktop\plink -i g:\sshkeys\sqluser.id_rsa.ppk myuser@211.999.999.999 ""rm myfile_20120727.csv""")

Dts.TaskResult = Dts.Results.Success

End Sub

Not sure if it's...

Got an example GSquared?

Thanks!

Yeesh, no. And regrettably, I can't remember how the issue ended. Sometimes the best workaround is to convince the consumer that they need something entirely different. 🙁

You presumed well.

I'm not horribly against the idea of dropping the FK,...

Great insight all.

There IS an FK between the tables. I'd rather NOT drop it.

The child table does NOT contain the archive_date field, but BOTH tables contain [license_message_id].

The way I've...

Kiwi, coming into this problem, ON CASCADE DELETE was my first inclination, because I assumed the SQL engine streamlined the 2nd table delete somehow. But after some research, I...

Yeah, that temp table approach is paying dividends.

create table #batchlist (

lm_id int not null primary key clustered

)

(It's faster with the explicit cluster, yes.) Haven't tried the table variable...

The explicit DELETE statements...

delete

v

from

license_message_value v

inner join license_message lm

on v.license_message_id = lm.license_message_id

where

lm.archive_date < getdate()

delete from

license_message

where

archive_date < getdate()

... so that [archive_date] field is the crux of the biscuit....

GSquared (5/17/2012)

---

There's a big difference between actually obsolete (buggy whips, crossbows), old and proven (speaking, wheel, knife), semi-obsolete but fashionable (cooking over fire), on-the-way-out (landline phones), and should-be-retired-already-but-isn't (coal power...

Thanks fellas. This could really pay dividends. I've got it on my calendar to tie this thread off with my experience in 2 weeks.

Sorry for not clarifying that... The DBF I'm trying to populate is a FoxPro "free table".

I've been trying the Microsoft VFPOLEDB.1 driver which seems to be the most recommended...

The maximum commit size and row per batch settings are only available on OLE DB destination objects with "Fast Load" checked, no? This doesn't seem to be an option...