I originally was pulling in an import table that had only yesterday's date (or the most recent date per id if there was nothing new yesterday) in it, so it...

Thank you. I like this. I have seen it before, but forgotten about it. Actually my purpose was just to make an easy way to review Update syntax. If this...

Thank you all for the input here. There is a lot to learn and digest. A few comments are in order.

First of all, I didn't include code because I designed...

The above post solved my problem. To answer your question, the inner query gave me more than one port_id. I misspoke when I said duplicates because I had been working...

That was it. I was close and didn't see it. Thanks.

Thank you for helping out. Here is my linked server script:

EXEC master.dbo.sp_addlinkedserver @server = N'MSDN_IMPORT', @srvproduct=N'Excel', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'\ccicmshr001\desktop services\DTS\Software Reporting\MSDN\MSDN user list for HR authentication.xls', @provstr=N'Excel 8.0; IMEX=1;'

EXEC...

Thank you for your response. Now I am really confused - The original question that I was asked said something like "Do we get the data via FTP (like some...

Thank you Eugene for the forum posting tips. Ironically, I just found, read them, and printed them about 10 minutes ago.

And Chris, I actually found that I had 2 different...

Thank you for the answeres.

Thank you. I have just started using CTEs in the last few weeks.

Thank you for getting me thinking in the right way. Your answer didn't work. It didn't like the 5 part columns in the CTE or the double dots .. in...

Thank you. I'll give it a try. But I don't have the proper rights to execute that yet.

Thank you. I forgot about appending the '%' to the parameter.

Thank you for your answer. I did not know anything about the DelayValidation.

So, the bottom line is, I must FTP to a folder first, and then import that file to...

Thank you for your reply. Does that mean that the dataset is actually a SQL statement? And when you are in Business Intelligence Development Studio, and you click on the...