Another option would be to include an ActiveX task in your DTS and use the FileSystemObject to interrogate the remote directory and do any file moving you require.

Assuming there may be more than two of them in there, possibly your best bet is to pass them in as a single string with a unique delimiter:

execute usp_temp '111-11-1111,222-22-2222,333-33-3333'...

I'm going to be self-conscious whenever I talk about work for the rest of the day :unsure:. I know I use both interchangeably, but I can't figure out under...

I have to admit that I only found it so quickly because I happened to be looking at this yesterday :).

I eventually gave up trying to do it correctly due...

Try here : http://technet.microsoft.com/en-us/library/ms178085.aspx

(Good luck - it's a bit of a monster calculation, although the one for non-clustered is even worse).

We did something similar to this at work. What I found useful wasn't so much how it classified me (probably equivalent to an ISTJ - no surprise there), but...

Er...it wasn't me that was having the problem. 😉

Sorry Phillip - spelled your name wrong in my last reply. :crying:

I think you may have misunderstood what Philip meant by "container". If you expand the list of options under the database in EM/SSMS, the first item in the list...

We had a similar problem where it was seeing numbers in the first load of rows and assuming it was a numeric column.

We fixed it by setting the following registry...

We had a query that did this sort of stuff using the "where @value is null and..." syntax, and the performance was really nasty.  If you can, it's much better...