Thanks everyone. Very good ideas.

I'll go with the customized solution in .Net 1.1 using CuteFTP SDK, we haven't moved to VS2005 yet.

SFTP is also worth considering.

DTS jobs are fine with scheduling, however as you rightly mentioned before, the feedback about FTP component of DTS isn't too good. DTS_FTP tool you mentioned in your previous post...

Thanks for the suggestions. I was looking for more like an off-the-shelve product, which could be easily scheduled.

Since we are inclined towards customizing code for this task has anyone looked...

Thanks for your suggestions...

DTS option seems to be better because we can't make changes to the database objects as per the second post.

Cheers

AJ

DBCC CHECKDB didn't return any errors. But DATEDIFF code provided in the last post did the trick. (It's kinda weird still, probably we need some latest patches)

Thanks everyone!!

Cheers

AJ

datatype of the PickupDate field is datetime

Thanks, I did try using YYYYMMDD format, '2006-03-02 00:00:00.000' and the format with three digit month name but same issue is happening.

It's not just the last row but...

Yes, it's only the @QUERY parameter that is throwing things out for me. No other sp_send_dbmail queries work.

Also, I forgot to add that it does work 1 out of...

Following book is quiet good for beginners:

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, Second Edition

by Ralph Kimball and Margy Ross

John Wiley & Sons © 2002

I did try putting in the matrix group name (and for that matter all possible names incl. dataset, rowgroup, colgroup etc) but it is producing weird pattern of results like...

SPID keeps changing, so I can't kill it based on that. Is there a way to kill based on ClientProcessID?