If you're pressed for time you may find the linked server path to be the one of least resistance. While you can do pretty much anything with SSIS, there's a...

opc.three (2/22/2011)

---

Kevin Dahl (2/22/2011)

---

I have actually tried doing the pivot and building the IN clause dynamically (using this approach http://www.simple-talk.com/community/blogs/andras/archive/2007/09/14/37265.aspx), but it turns out that the column names actually end...

opc.three (2/22/2011)

---

Building a PIVOT query dynamically is a viable option. Using your DDL I created a simple PIVOT query:

SELECT pvt.RecordID,

pvt.Variable1,

...

No one with any suggestions for alternatives?

Our case with MS is still open, they say they've got a fix in the pipe and it may actually be delivered in a...

I can identify with all of the issues listed in this thread, as I've gone through much the same. I'm mainly writing C#/TSQL as well, and switching over to SSMS...