Getting back to the original problem, there are 46 columns in the table, but how many of them are required to ensure uniqueness?  You only need to partition by the...

Neil has, in my opinion, the best approach to the problem.  Here's an article by Wayne Sheffield on the technique that explains it well:  http://www.sqlservercentral.com/articles/comma+separated+list/71700/

You don't need to install FileZilla on the server to use http://FTP.  Windows comes with an FTP client built-in.  I've used it to automate downloading files from a server using...

A nice and simple way to end the week.  Thanks, Steve.

For those in the US, have a great 4th of July weekend.  Be sure to eat too much....

If I'm reading your question correctly, this looks like a string splitting exercise.  The function in Jeff Moden's article at http://www.sqlservercentral.com/articles/Tally+Table/72993/ will be a great asset here.  Once...

Talking to your application owners is never a bad idea.  I'd start there.  I hope this isn't the case, but if anyone's using the sa login, get them to change...

I think everyone on this thread knows that I don't know SSIS.  That said, can you fire a DOS command?  If so, this ought to do it.

del...