I had tried that.  The table is 8 million rows right now and even trying to limit it to a specific unique ID the server basically locks up on the...

I'm not sure what version of SQL that my BI tool rides on (Sisense).  I was looking through it for any solution and the only thing I found was self-joins...

This is maybe not the right forum/version as I don't have the "lead" function that I can use/find.  Is there a true "SQL" based solution using something like the self...

Thanks for the reply, however I'd actually already set that up, for that very reason.

Just not sending externally, and the other issue is the fact that it sends...

pduplessis,

Yours is slightly more complex than mine, (I think your developer and myself both found/modified the same code snippet for this), but what I'm running into that doesn't work correctly...

It's not that. You are correct however that filenames is a string array, however my problem isn't transferring the file.

It's that I'll send the file up/down and it will...

There is no need to check for bye, etc.

This is using the following line:

http://ftp.ReceiveFiles(fileNames, "DOWNLOAD_PATH", True, False)

It's all very basic overall and should be handled gracefully by Microsoft,...

All of my reports are internally used, so I just did the horribly bad route and changed the login to a domain account with rights to everything and left it...

That worked flawlessly.

Thanks greatly!

Bad assumptions and logic were what you might have missed.

I was trying to use an order by clause to give me the data in the order I wanted it and...

Kenneth,

That would be a good way to accomplish this task and one I hadn't thought of honestly.

But what I was talking about was using @@Error to try to catch the...

Yeah, there is supposed to be a way to trap this error in TSQL and handle it programmatically (I was talking SSIS for a different aspect of fail/success). But...

I've tried to find a way to handle it multiple times and ways, but I've never found out how to actually capture it and programmatically ignore it.

Granted, I use SQL...

Jeff,

That's actually a bit of a misnomer in that it won't fail.

You're correct, it does end up going through, however it shows to the client that an "error" occurred. ...

Here is what I think is happening, but not sure how to prove it.

The table being imported into is indexed against duplicates based on cust_id field.

What I'm thinking is that...