David,

If you've added that extra column, there's no need to use the IN() clause. You can just do the variables as I stated previously and use a "WHERE MyNewCol...

MERGE JOIN is something I'll look into. The one time I played with it, I couldn't quite figure it out. I can't remember exactly what my problem was...

Michael,

Actually, the SSIS package I'm building is pretty huge already and the last few times I tried to use LOOKUP, my performance ended up being worse than using a stored...

When you say your IDs aren't sequentially, what exactly do you mean? Could you give us a RL example of several IDs so we can see?

You could use a...

Sebastian,

Enable logging on the package to see where your problem might be. Also, consider running Profiler while running the package.

Lastly, have you tuned your initial queries? It might speed...

Open up Integration Services in SSMS to Server A. Right click package in question. Click "RUN PACKAGE" and do NOT panic... @=)

Window will pop up. Pick all...

Hmm. I was going to recommend using the Row_Number() function to build your original query, then realized your post sounds like you're not pulling your source records from SQL...

Peter,

I'm trying to avoid setting a variable if I can. I want to read directly from the table that I've got set up. I'm going to have a...

Darnit. Still coming up with NULL as my result. The XML column has data like below (though there are more elements than I've listed):

&ltrow xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&gt

&ltAgentID&gt11&lt/AgentID&gt

&ltAgentName&gtLuke...

Ahha! I was taking the CAST part of the referenced article too literally. I found a different article on MS's site that references the type of query I'm...

Hmm. Interesting article. I'm going to have to play with it, though, because it looks like it won't allow me to select the column from the table directly.

Thanks for...

There are several ways of turning this into XML. How do you want the XML document to look?

You could have everything listed as Elements in the root:

root

Element1...

Wow. Solution is not intuitive at all, but it does exist.

Right click the actual Solution name & go to properties. Pop-up window comes up with Configuration at top...

The steps above are the closest you can come to a practical solution.

You can also look in sysjobhistory to find out which jobs did NOT run during the time frame...

I don't know. I wish I did. I have the same issue.

I think maybe Microsoft needs to be contacted about this, but since someone else always installs our...