With the pivot you make your two records into one single record, which you can feed into an update statement.

Why didn't you start your own thread instead of hijacking an existing one with different requirements?

Check out the pivot transformation, it suits your requirement nicely.

I'm afraid such data is not available. As you found out yourself already, only the creation datetime is stored.

You could add your own logging columns using defaults and triggers, but...

If 2005:

Use a dataflow with an OLE DB source to read the data. Use a lookup on the destination table to retrieve the business key and the primary key. Do...

Easy question. I didn't even had to check to 3rd query, because the second one gave (NULL,0) and there was only one answer in the list with that option 🙂

The...

Phil Parkin (12/20/2012)

---

Koen Verbeeck (12/20/2012)

---

A very elaborate workaround:

you could use the Export column to export each location to a seperate flat file (you'd need to combine all the data columns...

My guess is MSDTC isn't running.

You can always try with the Execute SQL Tasks as I mentioned earlier.

Check out the various solutions in this blogpost:

SSIS error “Failed to retrieve data for this request”: reasons and resolutions

What's the error?

Enable transactions in your SSIS package. You can either use the built-in transaction mechanism which uses MSDTC, or you can create your own transaction by putting a SQL Task with...

What is the error user 2 gets?

My guess is DCOM permissions aren't set up correctly.

I personally wouldn't use event handlers, but use precedence constraints.

I'd put all the tasks in one sequence container. After the sequence container, I would put two Execute SQL Tasks: one...

A very elaborate workaround:

you could use the Export column to export each location to a seperate flat file (you'd need to combine all the data columns you need and then...

In the For Each Loop, there's a checkbox "Traverse subfolders" (if the For Each File enumerator is selected). Is it checked?

Yes, by saying your explanation is insufficient...

edit: I forgot to mention: thanks for the effort to create and submit a question. Hopefully...